I had this working for about a year.  I set up SQL mail with outlook installed on the SQL Server as the email client.  I set up an email account...

You will find lots of examples using ESRI software here.  http://www.esricanada.com/english/transportation/default.asp

There are several links to case studies and ESRI technical material.

If you are looking for a more "imaginative and...