Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 173
  • Last Modified:

Excel VBA - Outook Message different fonts

Hi

In using Excel VBA to send an Outlook message is it possible to control the font size type and color for each line?
0
Murray Brown
Asked:
Murray Brown
2 Solutions
 
KimputerCommented:
Yes, compose the outlook message in html format.
0
 
nutschCommented:
When you create the email, use .htmlbody instead of .body, and set bodyformat to 2 (html).

Set Itm = App.CreateItem(0)
.htmlBody = "<html><body>My Body</body></html>"
.bodyformat = 2
0
 
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
Thanks very much
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.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now