Delete message after sending

[Guest]

I am running VBA behind Excel to send spreadsheets automatically. These
attachments are bogging down my Sent Items. So I am exploring two options.

Option 1: Ideally, I would like to add code within the Excel sheet after
sending the email to automatically delete. That way it would work for any
user running the macro from any machine.

Option 2: Other option would b to program within Outlook to automatically
delete messages with certain criteria from the sent items. This option would
be Outlook specific, so each user would have to have this code within their
Outlook. Not ideal, but if Option 1 is not possible, fine. Criteria for
deleting could be a key word in the subject combined possibly with an
attachment. The emails are also sent only to blind copied people, so ithere
is actually no name in the To box.

Any ideas???

 

[Sue Mosher [MVP-Outlook]]

In your code that sends the message with the attachment, set the message's DeleteAfterSubmit property to True.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

 

[Guest]

UNBELIEVABLE!!! I figured I would get the help from the Mrexcel forum, but
they just provided complicated answers. Your solution is EXACTLY what I was
looking for! THANKS!