Here's a list of resources for AppleScript and Automater. If you find more, share them!

AppleScript

http://macscripter.net/
http://www.apple.com/macosx/features/applescript/
http://www.scriptweb.org/
http://www.scripting.com/
Apple's Introduction to Scripting
Apple Script Tutorial

Automator

http://macscripter.net/
http://automatoractions.com/
http://www.apple.com/downloads/macosx/automator/
http://www.automatorworld.com/

Brief list of scriptable applications. Of course many more are scriptable to an extent, but this is a list of majorly scriptable applications. Check out GUI scripting section for instructions on how to activate it.

Here is a link to a set of MS Office Automator actions.