I have a macro that generates a personalized email for each row that data (fname and email) exists. In a specified cell, I have the email message, but can not get any formatting to get carried into the generated email. All text goes in the email as normal (no bold, italics, etc). Is there any way I can get that text to format correctly in the generated email? Even if it takes placing some text in the actual message and then substituting something when the macro runs (which I do now to insert line breaks), that would be fine. If only there existed a hex value for bold beginning anf bold ending..

Any ideas?