send attachment from outlook automatically

  • Thread starter Thread starter Cam
  • Start date Start date
C

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
 
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.
 
Back
Top