Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi!
From VBA, no matter if I am using Outlook, or Outlook Express (must work in both) I would like to display the mail application, "not sending anything", just display. something like, from Ron de Bruin: Dim OutApp As Outlook.Application ' but what happen with Outlook Express Dim OutMail As Outlook.MailItem Set OutApp = CreateObject("Outlook.Application") Set OutMail = OutApp.CreateItem(olMailItem) With OutMail .To = " .CC = " .BCC = " .Subject = "This is the Subject line" '.Body = "Hi there" '.Attachments.Add ("C:\test.txt") .Display '.Send 'or use .Display End With Set OutMail = Nothing Set OutApp = Nothing But I do not get the mail, when .Send, and In one other workbook I get a error message due to Option Private Module,Option Explicit "I think so, I am not sure" I have to display Outlook, or Outlook Express, from vba, and I can't! Any Help..? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Outlook vs Outlook Express | Excel Discussion (Misc queries) | |||
Using Outlook Express Rather Than Outlook | New Users to Excel | |||
how to make OUTLOOK EXPRESS mail recipient in excel | Excel Discussion (Misc queries) | |||
Send to Outlook 2000 not Outlook Express | Excel Discussion (Misc queries) | |||
moving 450 active e-mail addresses from Excel to Outlook Express | Excel Discussion (Misc queries) |