[Note: I assume you have set up and configured Database Mail. If not, check this link Database Mail Configuration Stored Procedures to use various stored procedures required to configure Database Mail. As an alternative, you could also use the SQL Server Surface area configuration tool to configure Database Mail]
Use the following script to send a mail from your Sql Server
@recipients = 'firstname.lastname@example.org; email@example.com; firstname.lastname@example.org',
@body = 'Just testing the mail',
@subject = 'Sending Mail using Database Mail' ;
Did you like this post?
|subscribe via rss||subscribe via e-mail|
|print this post||follow me on twitter|