![]() |
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