This is the first result from Google:
http://www.datasprings.com/resources/articles-information/creating-email-triggers-in-sql-server-2005
Seems to cover what you need.
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.