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

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