Outlook
 

I have been using the following to talk to Outlook from Excel

Set OutL = CreateObject("Outlook.Application") 'this will launchOutlook
(Hidden)
Set NewMail = OutL.CreateItem(0)
NewMail.Subject = UserForm1.TextBox1.Value
NewMail.To = ActiveCell.Value
NewMail.Body = UserForm1.TextBox2.Value
NewMail.Send


Is there any parts of Outlook that can be accessed other than "To",
"Subject" and "Body", Ideally I would like to access the Source of the
message body so that I could send HTML to it and create emails that are
formatted?

I am using Office 97

Outlook
 

Stuart

You can access virtually an property that you can change in Outlook's UI.
You cannot, however, access the HTMLBody property in versions prior to
OL2000. This site was tested for XL2000 and OL2000, but I believe the
2000-only properties are noted:

www.dicks-clicks.com

--
Dick Kusleika
MVP - Excel
www.dicks-clicks.com
Post all replies to the newsgroup.

"Stuart" wrote in message
...
I have been using the following to talk to Outlook from Excel

Set OutL = CreateObject("Outlook.Application") 'this will launchOutlook
(Hidden)
Set NewMail = OutL.CreateItem(0)
NewMail.Subject = UserForm1.TextBox1.Value
NewMail.To = ActiveCell.Value
NewMail.Body = UserForm1.TextBox2.Value
NewMail.Send


Is there any parts of Outlook that can be accessed other than "To",
"Subject" and "Body", Ideally I would like to access the Source of the
message body so that I could send HTML to it and create emails that are
formatted?

I am using Office 97