I have a VBA program that creates an Outlook email in html format. The email contains some html tables. Sometimes the email is cut off in the middle of a table.
I've checked for stray single quotes in the data and there are none. Is there a length limit to Outlook emails created with VBA?
Is there anything else that could be causing the email to be cut short?
Here's the code that creates the email.
.To = "email@example.com"
.BodyFormat = olFormatHTML
.HTMLBody = "<html><body style=""font-family:cambria; font-size:.9em;"">" & emailBody & emailBody2 & " </body></html>"
.Subject = strEmailSubject