Retain the text format for a Email Body while sending mail with VBA

[Ravisca2003]

Disclaimer : I am also posting for help in other expert forums also . Hope this is not a breach to use this forum.

I am using a Macro at my office which uses concatenation of six variable lines since I wanted to introduce " Next Line" . However the problem i identified is that when the code is executed to send email, the email body is loses all its format and uses simple text format in email.

Question - Can I Use one Cell , lets say A1 and put my mail body in the format I wish and VBA can pull this cell "As it is" . "As it is the Key" here. Please help.

Untitled picture.png

Please Login or Register  to view this content.

[mrice]

I would suggest that you switch to using HTML format for the e-mail and build the necessary tags for the formatting into your code. I've done this in similar situations.

[Logit]

.
Basic example :

Please Login or Register  to view this content.

[LJMetzger]

The following is a simple working example using .HTMLbody for multiple lines. HTML uses '<br>' for the newline character instead of Carriage Return / Linefeed.

Please Login or Register  to view this content.

To convert existing code that has carriage return linefeed into HTML compatible code use a construction like:

Please Login or Register  to view this content.

I hope this helps.

NOTE: Firewall prevents use of actual code. Replace qqq with < in all code above (3 places)

Lewis