ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Display mail application either in Outlook, or Outlook express (https://www.excelbanter.com/excel-programming/294986-display-mail-application-either-outlook-outlook-express.html)

[email protected]

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..?


All times are GMT +1. The time now is 05:21 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com