I have the following text in cell A1 of my worksheet (Sheet1):
-------------
abc. 123.
I am John.
Regards,
John
-------------
I have this code to create a email with the text in cell A1.
However, when the email is generated, the formatting, spacing, font of the text changes to a single line in Times New Roman, font size 12:
----------
abc. 123. I am John. Regards, John
----------
The question I have is, is there a code that can maintain the formatting/line breaks of the text in cell A1 in the email body?
I am using Excel 2007 and Outlook 2007 (default: html message).
Appreciate any help or sample code i can get. Thanks!
Bookmarks