SQL Server Send HTML Body email with spsenddbmail

In this article I will explain with an example, how to send html body email with sp_send_dbmail in SQL Server.

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 for sending emails, you are now ready for sending html formatted emails.

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

DECLARE @messageBody NVARCHAR(1000) = 'Happy Birthday Mudassar Khan. '

+ 'Many happy returns of the day.'

+ ' ASPSnippets Team'

EXEC msdb.dbo.sp_send_dbmail

@profile_name = 'mudassar_Email_Profile'

,@recipients = 'recipient@gmail.com'

,@subject = 'Email from SQL Server'

,@body = @messageBody

,@body_format = 'HTML'

,@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.

Download Code

Description is required.

SQL Server: Send HTML Body email with sp_send_dbmail