Passing HTML tags in sp_send_dbmail body

• peer_mohamed2k

  Mr or Mrs. 500

  Points: 510

  More actions

  March 6, 2009 at 4:56 am

  #131588

  Hi,

  I would like to use sp_send_dbmail for sending mails. There in the body, I want to pass HTML tags like in the body parameter. So that When the user clicks on the link in the mail, it should openup the page.

  But HTML passes whatever we pass inside the parameter samething it is displaying all the tags.

  If anyone encountered this, please let me know.

  Thanks,

  Peer Md.

• Jack Corbett

  SSC Guru

  Points: 184394

  More actions

  March 6, 2009 at 9:34 am

  #955024

  Are you using the @body_format parameter and setting it to 'HTML' like this:

  EXEC msdb.dbo.sp_send_dbmail @recipients = 'your_name@your_company.com', @subject = 'test',

  @body_format = 'HTML', @body = '<b>Test</b> This works'

  edit: Used the encode values for the the html tags so that they would show in the code block.

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question