Do not save email in sent items

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
Click to expand...

You need to employ VBA code to access the Outlook object to send your
message. Then use
myItem.Send
myItem.Close olDiscard
 
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
 
Back
Top