Format text

E

eran

Hello,
Is there any way to format text (font, size etc) when sending email
from Excel VBA?

Thanks a lot,
Eran
 
S

Sue Mosher [MVP-Outlook]

Yes, build your message content with HTML tags. After you use CreateItem to create your OUtlook MailItem, set its HTMLBody property to the fully tagged -- including any formatting -- HTML content:

objMailItem.HTMLBody = "<html><body><p><strong>" & _
"THis is in bold.</strong></p></body></html>

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
 
Top