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
|