Automate emailing PDF attachement using Outlook or Access

[DarS]

I am looking for a way to email pdf reports using Outlook or Access without
user intervention. Is it possible to get an email to send without clicking
the Send button? I will be using version 2007. Any suggestions are
appreciated.

Thank you

 

[Arvin Meyer [MVP]]

Have a look at my code at:

http://www.datastrat.com/Code/OutlookEmail.txt

It uses Early Binding, but you can easily change that. The code also will
send the email without displaying Outlook. One caveat. If Outlook is not
open, the email will stay in the Outbox awaiting Outlook to be opened.

 

[bporter55373]

Hi Arvin,

Is there anyway to disable the Outlook security popup? I had to use a 3rd
party product from mapilab to suppress these prompts.

Thanks
bporter