VBA to force Outlook to send email in HTML format rather than RTF

[Human_doing]

Hi all,

Does anyone know if it is possible to use Excel VBA not just to send an email through Outlook but to force the email to be sent using HTML format rather than plain text or RTF? I have some working code that uses rangetohtml function but many users in my organisation do not have their default email set to HTML, therefore when they attempt to use the code, the HTML-based VBA is just ignored and the email appears blank.

Many thanks in advance for any help,

 

[pman]

Try putting this in when you create your mail object:

objMail.BodyFormat = olFormatHTML

 

[BrianExcel]

Ron DeBruin's site offers this. The body needs to use the .HTMLbody function.


http://www.rondebruin.nl/mail/folder3/mail4.htm

 

[Human_doing]

Hi guys, thanks for your help on this that's great,

Thanks!

 

[Dossfm0q]

May you apply/add your Idea for

http://www.mrexcel.com/forum/showthread.php?t=612286