Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 8
Default Display mail application either in Outlook, or Outlook express

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Outlook vs Outlook Express MsNat Excel Discussion (Misc queries) 1 October 21st 09 10:10 PM
Using Outlook Express Rather Than Outlook Robert11[_3_] New Users to Excel 2 March 6th 09 11:06 PM
how to make OUTLOOK EXPRESS mail recipient in excel mihir shah Excel Discussion (Misc queries) 1 November 6th 05 02:10 PM
Send to Outlook 2000 not Outlook Express Jimbo Excel Discussion (Misc queries) 2 January 4th 05 08:19 PM
moving 450 active e-mail addresses from Excel to Outlook Express ragman10 Excel Discussion (Misc queries) 1 December 2nd 04 03:25 PM


All times are GMT +1. The time now is 03:10 AM.

Powered by vBulletin® Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright ©2004-2023 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"