VBA code for email body

[christinap]

Can anyone post a reference for the code needed to create an email message from excel? I am able to populate an email message with words but I am wondering if there is a way to make certain words Bold, or how to space down to the next line, different size font, etc???

 

[bugmonsta]

Hi

Visit Rons page at http://www.rondebruin.nl/win/s1/outlook/mail.htm, this is the page that I encourage anyone who is sending emails to have a look at.

The http://www.rondebruin.nl/win/s1/outlook/bmail4.htm page shows about adding in carriage returns (space down) and if you know a little bit of html that will be handy as it uses the same coding, for bold, italic etc
Rons pages are very detailed, and may look a little complicated but I can honestly say they are very easy to follow and the examples he has their cover nearly all expectations.

 

[daverunt]

Hi,

You can also look here for some pointers.

https://www.mrexcel.com/forum/excel...bold-one-line-email-sent-via-vba-outlook.html

There's a (still valid) link to a text file, which should give you an idea of how to change text colour and use the bold tags. Break tags (br) start new lines.

You must use .HtmlBody and not .Body in the mail.