| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Thru VBA, how do I e_mail with ONLY ONE CLICK ?
Hi.
I regularly email Excel workbooks. To make it more convenient, I have included [Application.Dialogs(xlDialogSendMail).Show ")] in my code. That line is used about 5 times sending the book to differrent recipients with various stages of confidentiality removed. My gripe is this: I've got to click 'send' the 5 times times my default mail server, Outlook Express, pops up. [ActiveWorkbook.SendMail ")] also requires a confirmation from Outlook Express. A solution to this hassle will be much appreciated. Thanks in advance, Jones. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Thru VBA, how do I e_mail with ONLY ONE CLICK ?
G'day Ced
You will find this link is what you are looking for http://www.rondebruin.nl/sendmail.htm HTH Mark. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| harry poter what has e_mail ? | Charts and Charting in Excel | |||
| E_MAIL WITH MATCHING... | Excel Programming | |||
| E_MAIL WITH MATCHING... | Excel Programming | |||
| E_MAIL WITH MATCHING... | Excel Discussion (Misc queries) | |||
| Click on graph bar to execute a double-click in a pivot table cell | Charts and Charting in Excel | |||
Linear Mode
