SQL Server 2008 R2 Express: Send email with CLR

In the Express edition of SQL Server the Database Mail functionality does not exist. Therefor you need an alternative way to send emails with T-SQL. One solution is to use a CLR stored procedure. In this post I explain how to do this.