Send Emails from SQL Server

If you need to send an email from SQL Server, you can use the following stored procedure:

sp_send_cdosysmail @From varchar(100), @To varchar(100), @Subject varchar(100), @Body varchar(4000)

NOTE:   We do not provided support when using this stored procedure, so use it at your own risk.