First of all you need to configure database mail, Please refer this article:
Now in query you need to provide @body_format tag to HTML like this and profile created profile name.
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.
Join the conversation! Your thoughts help the community grow.