Opening a new mail dialog box in Excel using vba

Posted to microsoft.public.excel.programming

MattShoreson[_6_] MattShoreson[_6_] is offline

external usenet poster

Posts: 1

Opening a new mail dialog box in Excel using vba

Set OL = CreateObject("Outlook.Application")
Set emlMessage = Outlook.CreateItem(olMailItem)
emlMessage.Attachments.Add "filename"
emlMessage.Subject = "title"
'emlMessage.To = "whoever"
emlMessage.Display

You'll need the outlook reference added via toolsreference in the vb
editor.

------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

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
Opening Excel - getting print dialog box	Christina Lynch	Excel Discussion (Misc queries)	0	August 31st 08 01:40 AM
Dialog box appears when opening Excel says it can't find a file?	Aloha6	Excel Discussion (Misc queries)	2	September 12th 06 01:03 PM
how do i create a dialog box to appear on opening an excel wkbook	lallyboo	Excel Discussion (Misc queries)	1	October 13th 05 06:52 PM
How can I make Excel display a message (dialog box) upon opening a spreadsheet?	Phill	Excel Discussion (Misc queries)	8	March 20th 05 06:22 PM
Opening an filling e-mail from excel	JMay	Excel Programming	0	September 8th 03 12:52 PM

All times are GMT +1. The time now is 11:42 PM.

Menu

About Us