Send Email in HTML Format using SQL database Mail

As we all know that database mail always send in plain text, In this blog we will send mail in HTML format.

First of all you need to configure database mail, Please refer this article:

Configure and send E-Mail from SQL Server

Now in query you need to provide @body_format tag to HTML like this and profile created profile name.