One of the nice things about SQL Server is the ability to send email using T-SQL. The downside is that this functionality does not exist in SQL Server Express. In this tip I will show you how to build a basic CLR stored procedure to send email messages from SQL Server Express, although this same technique could be used for any version of SQL Server.
If you have not yet built a CLR stored procedure, please refer to this tip for what needs to be done for the initial setup.
View Complete Post