Excel VBA Building an HTML body for an emal

Hi
I have started using the following code to build an HTML body for an email
How do I change Font color and do a line return?

oMsg.HTMLBody = "<html><body>My Body</body></html>"
oMsg.BodyFormat = 2
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAsked:
Who is Participating?
 
MacroShadowConnect With a Mentor Commented:
There are many WYSIWYG free  online html editors, you design the text as you like and it returns the html.

www.onlinehtmleditor.net/¿

http://www.quackit.com/html/online-html-editor/
0
 
Pratima PharandeConnect With a Mentor Commented:
Try this

oMsg.HTMLBody = "<html><body><font size=3  color=red>My Body </font></body></html>"
0
 
Rgonzo1971Connect With a Mentor Commented:
Hi,

pls try

oMsg.HTMLBody = "<html><body><font size=3  color=red>My <br>Body </font></body></html>"

Open in new window

Regards
0
 
KimputerConnect With a Mentor Commented:
For different sizes, colors and line returns:

oMsg.HTMLBody = "<html><body><font size=3  color=red>line 1</font><br><font size=2  color=blue>line 2</font><br><font size=1  color=green>line 3 </font><br></body></html>"
0
 
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.