[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 171
  • 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

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering 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