HTML format in sp_send_dbmail

Question

I formatted sp_send_dbmail to send HTML email. But it sends mail with HTML code.

Below is the code I used

EXEC msdb.dbo.sp_send_dbmail @recipients=N'*****@********.com', @body= '<font color="green" face="arial"><i> Testing<br /> </i></font><hr />', @subject = 'SQL Server Trigger Mail', @profile_name = 'DBMailProfile1' 

Answer 1

You must also specify @body_format = 'HTML' . The default is TEXT .

See sp_send_dbmail on MSDN: there are also HTML examples