Using HTML tags in Excel VBA

Hi All,

I have code that sends a message through Outlook. My problem is because I use .HTMLBody the coding ignores my vbcrlf. I would have to use <br> but Excel immediately gives me an error message if I use that.

Any suggestions appreciated.


Thanks.

Here is a piece of my coding:

Please Login or Register  to view this content.

SubjMsg is String message that uses ranges from the worksheet and combines them with some string. Ex. "Here is text" & Range("A1") & " Some more text".

Summary is a range that consists of two columns of data with headers

Thanks Norie that worked perfect!