View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
billw billw is offline
external usenet poster
 
Posts: 2
Default Creating formatted Outlook Msg from VBA

Hi,

Is there a way to create e-mail messages in Outlook via
Excel VBA with formatted (i.e. bold, colored) text. I am
currently passing in the string "MailBody" to Outlook
using the following code. This code inserts an unformatted
text string?

Dim OklApp As New Outlook.Application
Dim OutLk As Outlook.MailItem

Set OutLk = OklApp.CreateItem(olMailItem)
OutLk.Body = MailBody

Is there any way I can insert formatted text?

Thanks,

Bill W.