send attachment from outlook automatically

[Cam]

Hello,

I have a macro in Excel to update data, then email the updated file to
people on the distribution list. The problem is once the macro is ran, it
popup a screen asking whether it is ok to send the email out (must be a
security reason in outlook?). I want to put in the code to by pass the popup
cause I want the macro to run automatically during the weekend.

Thanks

 

[Daniel Pineault]

THere are various approaches depending on your application. Take a look at
the following

http://www.slipstick.com/outlook/esecup.htm (Automation Security)
http://msdn2.microsoft.com/en-us/library/aa168346.aspx
http://www.dimastr.com/redemption/
http://accessblog.net/2006/12/auto-click-yes-to-outlook-security.html
http://www.mapilab.com/outlook/security/

 

[ND Pard]

While using the

docmd.sendobject

statement in Access 2007, I keep getting an Outlook dialog box that says,

"A program is trying to send an e-mail message on your behalf. If this is
unexpected, click Deny and verify your antivirus software is up-to-date."

Fortunately, we have a SMTP server, and I was able to use (modify) the code
posted by BCullenward from the site:

http://www.access-programmers.co.uk/forums/showthread.php?t=97854

Now, it works GREAT! And is super fast too. No more security alerts from
Outlook.

I hope this helps.