PDA

View Full Version : [SOLVED:] Convert Text body in email to HTML



frankie
12-02-2016, 09:44 AM
Hello,

I have created a macro from an Excel file that copies and pastes cells from an Excel file into an Outlook email in Formatted text (it is a formatted table). It works well except I want to convert this email format from Formatted text to HTML afterwards to send it in HTML format.

Do you know a simple of doing this? I really looked for hours on Internet but could not find the solution.

Many thanks for your help!

Frankie

frankie
12-02-2016, 10:04 AM
I found the solution myself, I needed to use .BodyFormat = 2. Hope it will help someone else

Kenneth Hobs
12-02-2016, 10:17 AM
Welcome to the forum!

Most are probably using the htmlBody property and Ron de Bruin's RangeToHTML(). http://www.rondebruin.nl/win/s1/outlook/bmail2.htm