Do not save email in sent items

[Emma Hope]

I have a macro that automatically send emails from my database, for security
reasons i want to stop that email from going into the senders sent items, is
this possible?

Or as a worst case scenario does anyone know how to get it to delete via
Outlook (from sent items and deleted items and not retrievable using Recover
deleted items)? I do not have access to my company's email system and this
rule needs to apply to everyone, so i cannot use Outlook vba.

Thanks
Emma

 

[Michael Bednarek]

I have a macro that automatically send emails from my database, for security
reasons i want to stop that email from going into the senders sent items, is
this possible?

Or as a worst case scenario does anyone know how to get it to delete via
Outlook (from sent items and deleted items and not retrievable using Recover
deleted items)? I do not have access to my company's email system and this
rule needs to apply to everyone, so i cannot use Outlook vba.

You need to employ VBA code to access the Outlook object to send your
message. Then use
myItem.Send
myItem.Close olDiscard

 

[Emma Hope]

Thanks for the advice. Unfortunately i don't know how to access outlook from
vba. I use SendObject in a macro which gives me all the stuff i usually need.

I need to open an email, add query as an attachment in xls/rtf/snp format,
add a number of email addresses in to & cc, change the subject, send
automatically and then delete the mail from the sent items.

I know its a big ask but does anyone know of any code i can copy and
personalise or help me do this, my vba is reasonable but limited to things
like select/if statements and value/enabled/locked type changes.

Thanks very much.
Emma

 

[Michael Bednarek]

[snip]

I know its a big ask but does anyone know of any code i can copy

[snip]

This should get you started: <http://support.microsoft.com/?id=209948>.