VBA Excel Breakdown for HTMLBody property

Asked Jun 10 '20 at 15:00

Active Jun 10 '20 at 15:00

Viewed 35 times

Good afternoon,

I am preparing the letter, which will be sent automatically from the macro. Unfortunately, I have encountered a problem with breakdown. Because the email is going to be big, I need the line breakdown for a few times. How can I do this properly?

 With OutlookMail
 .BodyFormat = olFormatHTML
 .Display
 .HTMLBody = "Dear " & Surveyor & " <br><br> Please attend <b><font color='red'>" & Site & "</font></b> at " & Adr & " on " & Dt & "." _
 "Site contact name and number"

This is my code snippet. Everything works fine until the end of the first line. After the breakdown, I am getting an error: Compile error: Syntax error:

How can I resolve it?

asked Jun 10 '20 at 15:00

Geographos

3

You're missing an `&`. – BigBen Jun 10 '20 at 15:01
1

As mentioned in the duplicate target, you need the line continuation character as well as an `&` to concatenate each line with the former one. – BigBen Jun 10 '20 at 15:09
1

Also, `Display` should be called last. It's the method to show the email for editing. – Kostas K. Jun 10 '20 at 15:19
Thanks a lot, I know it now :) – Geographos Jun 10 '20 at 15:31

VBA Excel Breakdown for HTMLBody property

0 Answers0