The December issue of Software Test & Performance Magazine (which you can download for free) has a great article on determining which tests are suitable for automating and which aren't.  The author, Bob Galen, presents several points to consider when making this critical decision.  He even throws in a few anti-patterns to watch out for when you begin your automation project.  It's a great read, especially if you're new to test automation!