| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sending Workbook
Hi
I have got a command button which sends the worksheet to the applicable mailbox however because the workbook is a large size (2000kb) I was wondering if there is a way to automatically delete the email from outlook so as not to clog up the mailbox. Any suggestions???? thanks Noemi |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Sending Workbook
Noemi wrote:
Hi I have got a command button which sends the worksheet to the applicable mailbox however because the workbook is a large size (2000kb) I was wondering if there is a way to automatically delete the email from outlook so as not to clog up the mailbox. Any suggestions???? thanks Noemi Hi Noemi, Try... With olNewMail .DeleteAfterSubmit = True .Send End With |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sending sheets in workbook | Excel Discussion (Misc queries) | |||
| VBA for sending workbook via Outlook | Excel Programming | |||
| sending only one sheet from a workbook | Excel Programming | |||
| Sending a workbook with a message | Excel Programming | |||
| Sending data to a different workbook | Excel Programming | |||
Linear Mode
