Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
I'm trying to streamline the sending of e-mails by Microsoft Outlook using VBA from Excel. My problem is that the code below (taken from www.rondebruin.nl) creates an "Rich Text Format" email, whereas I need the message in "Plain Text". Can anyone help? Thanks Shane Sub Mail() Dim olApp As Outlook.Application Dim olMail As MailItem Application.ScreenUpdating = False Set olApp = New Outlook.Application Set olMail = olApp.CreateItem(olMailItem) With olMail .To = " .Body = "Hello" .Display End With Set olMail = Nothing Set olApp = Nothing Application.ScreenUpdating = True End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
"excel "macros may be disabled" message using an xlam file | Excel Worksheet Functions | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
how to eliminate E-mail "To" & "CC" boxes at top of Excel Sheet | Excel Discussion (Misc queries) | |||
How do I ignore the "Number stored as text" error message permane. | Excel Discussion (Misc queries) | |||
"word unable to open data source" message when trying to do mail m | Excel Discussion (Misc queries) |