CDO Mail - HTML Body

[MikeMcKeown]

I have a CDO stored procedure which works and send out emails. However I would now like the body of my email to be HTML so that I can apply formatting to the text.

However I am unsure how to set up the HTML tags and where to put them. I have change the main SP to this:-

EXEC @hr = sp_OASetProperty @object, 'TextBody', @body
EXEC @hr = sp_OAMethod @object, 'Send', NULL

Currently I am doing the following:-


exec sp_cdo_sendmail @rec, 'sender address', @subject , @body

These are variables which are set to a field from the database.

How do I create the @body to be HTML?

Thanks in advance,

 

[MikeMcKeown]

Sorry - Realised that I did not change it to HTMLBody