Unable to write code with more than 25 physical lines to create Outlook Email.

Hi Guys,

I hope you are all well.

I use a Userform to create an email to send to customers.

The problem is that I can only create an email with only 24 physical lines in the .HTMLBody.

Is there a way or a workaround so itīs possible to create an longer email through VBA?

I have found the issue in the following link:

https://msdn.microsoft.com/en-us/lib.../gg264236.aspx

Your assistance on this matter will be highly appreciated.

Best regards,
Filipe Oliveira

You simpy have too many Line Continuation characters (& _ at the end of a line) - nothing to with the number of physical lines in an email.

Just start again concatenating the string. Repeat as often as needed.

Please Login or Register  to view this content.

Hi grimes0332,

Thank you so much for your reply.

I was exactly what I was looking for.

Really appreciated for your support.

Best regards,
Filipe

Hi shg,

Thanks for your reply.

Unfortunately is not simple literal text. The Userform have some TextBoxes that the value will be inserted in the middle of the text body of the email. The UserForm populates data from a table as well.

The solution provided by grimes0332 solved the problem big time.

Thanks anyway for your support.

Best regards,
Filipe