Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I'm using the following line of code to send a workbook to a specific
recipient. Application.Dialogs(xlDialogSendMail).Show "recipient" It works fine, but the email dialog box remains open (which I want), and the macro will not continue until the email is either sent or closed. I want the macro to continue running regardless of whether the user actually hits "Send" or not. I've also tried: ActiveWorkbook.SendMail Recipients:="recipient" But this automatically sends the email without giving the user a chance to type anything in the message body of the email. How can I get the email dialog to appear and remain open for the user to add a message to, but also keep the macro running? Any ideas? Using: Excel 2003, GroupWise 8 Thanks in advance! Elkar |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Send To Email recipient one sheet from workbook | Excel Discussion (Misc queries) | |||
Excel VBA macro to send email attachment from default email client | Excel Programming | |||
send 1 sheet of a workbook in email - Excel 07 | Excel Discussion (Misc queries) | |||
Macro to send email to person in workbook list of users | Excel Programming | |||
How do I send/email macros from my excel workbook to someone else? | Excel Worksheet Functions |