Embed HTML in generated email body

[Steve]

I am working on a project that generates an email from various cells within
an excel speadsheet. Some of the data is critical and needs to be BOLDed or
Red Text. I've setup Outlook to default to HTML and that works fine. When I
send a string:

Email_msg = "Your action item is " & <strong> & "Critical" & </strong> & "!"

my actual email body contains:

Your action item is <strong>Critical </strong>!

Can anyone help me embed the actual HTML information?

Thanks.

Steve Blake

 

[Norman Jones]

Hi Steve

As for most email related questions, visit
Ron de Bruin's Email pages at:

Example Code for sending mail from Excel
http://www.rondebruin.nl/sendmail.htm

See particularly:

Mail a row or rows to each person in a range (HTML)
http://www.rondebruin.nl/mail/folder3/row2.htm

and see the section entitled: HTML text

on Ron's page:

Sending mail from Excel with CDO
http://www.rondebruin.nl/cdo.htm