Format text

  • Thread starter Thread starter eran
  • Start date Start date
E

eran

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

Thanks a lot,
Eran
 
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
 
Back
Top