Paragraph formatting of Outlook email created from VBA
Posted on 2014-01-07
I am currently generating an email from a macro in excel to send to customers. The problem I am having is that it is double-spacing all the paragraphs when I press enter. I noticed that if I go into format text / paragraph / spacing for the email and check the box for "don't add space between paragraphs of the same style" pressing enter only single spaces my lines. How can I get that box checked from vba when creating the email? I have searched and searched and have not found anything that seems to address my issue.
Here is the .HTMLBody statement I'm using with its attributes:
.HTMLBody = "<p style='font-family:courier new;font-size:14'>" & hlink & "</p>"