Look at the Database Mail component. It works nicely for my applications. I was even able to make it work on SQL Server Express edition, though to make it so I had to borrow a couple of files from a Developer's Edition.

http://www.databasejournal.com/features/mssql/article.php/3626056/Database-Mail-in-SQL-Server-2005.htm