Send Email in SQL Server using Stored Procedure

In this article I will explain with an example, how to send email in SQL Server using Stored Procedure.

This article will illustrate how to send email using sp_send_dbmail Stored Procedure in SQL Server by using GMAIL SMTP settings.

This article is applicable to following SQL Server versions i.e. 2008, 2008R2, 2012, 2014, 2016, 2017, 2019 and 2022.

In order to start sending emails, the very first thing to be done is to configure SQL Server for sending emails from Database.

Thus, in order to achieve the same, please refer my article Configure SQL Server for sending emails.

Once the SQL Server Database is configured, you are now ready to send emails.

In the following SQL query, the SQL Server using Stored Procedure sp_send_dbmail is used to send an email from SQL Server.

EXEC msdb.dbo.sp_send_dbmail

@profile_name = 'Mudassar_Email_Profile'

,@recipients = 'recipient@gmail.com'

,@subject = 'Email from SQL Server'

,@body = 'This is my First Email sent from SQL Server :)'

,@importance ='HIGH'

Once executed, the following messages will appear which confirms, your email has been queued.

Once the Stored Procedure sp_send_dbmail is executed, the mails are queued and then sent.

In case you do not receive email, then you can find the status of email i.e. sent, unsent or failed using my article Find email sent status using sysmail_sentitems in SQL Server.

The possible errors (exceptions) occurring while sending email using GMAIL SMTP are covered in the following article.

Description is required.