Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
custimized outlook today in outlook 2007 | Excel Discussion (Misc queries) | |||
excel open in outlook if outlook is running | Excel Discussion (Misc queries) | |||
Send to Outlook 2000 not Outlook Express | Excel Discussion (Misc queries) | |||
Outlook 2003 demo back to Outlook XP | Excel Discussion (Misc queries) | |||
Outlook vs Outlook Express | Excel Worksheet Functions |