Results 1 to 1 of 1
2013-08-21, 13:29 #1
- Join Date
- Feb 2003
- Piscataway, New Jersey, USA
- Thanked 0 Times in 0 Posts
vbcrlf in vba using Redemption Outlook automation creates extra carriage returns
I've been automating Outlook emails from MS Access successfully for years, but lately the formatting is not perfect.
Currently, I'm using createobject(outlook) to initialize Outlook and Redemption to avoid security snafus.
When I create strings to include in the body of the email message, sometimes (not consistently), although vbcrlf creates perfectly formatted messages in Access, when the emails are delivered, the Outlook emails have extra vertical spaces in some places. This is inconsistent behavior. I've tried vbcr instead, but no luck.
Has anybody else experienced this and, if so, do you know a solution? Is there another vba method I should use to create a single return?
Thank you, in advance, for your help.