Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Opening a new mail dialog box in Excel using vba
Hi,
I would like to use Excel that runs a macro to open up a new mail in Outlook. I would also like to put in a generic body message and subject line, but they would have to be able to pick who they would like to email it to as it different everytime. I can only do this if they were sending the file along with it, but is there anyway of doing this without attaching the file? Any help would be much appreciated. Michelle |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Opening a new mail dialog box in Excel using vba
Hi Michelle,
I would like to use Excel that runs a macro to open up a new mail in Outlook. Like this: Sub MailIt() Dim oMailItem As Object Dim oOLapp As Object Set oOLapp = CreateObject("Outlook.application") Set oMailItem = oOLapp.CreateItem(0) With oMailItem .To = .CC = .Subject = "Your subject goes here" .Body = "Hi there!" .Display End With Set oOLapp = Nothing Set oMailItem = Nothing End Sub Regards, Jan Karel Pieterse Excel MVP www.jkp-ads.com |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Opening a new mail dialog box in Excel using vba
Hi Jan,
Thank you very much for your response. That's exactly what I want to do!! Regards, Michelle *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Opening Excel - getting print dialog box | Excel Discussion (Misc queries) | |||
Dialog box appears when opening Excel says it can't find a file? | Excel Discussion (Misc queries) | |||
how do i create a dialog box to appear on opening an excel wkbook | Excel Discussion (Misc queries) | |||
How can I make Excel display a message (dialog box) upon opening a spreadsheet? | Excel Discussion (Misc queries) | |||
Opening an filling e-mail from excel | Excel Programming |