• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 214
  • Last Modified:

Send email from MS Access macro

I would like to send a confirmation email when a macro is run. The macro is run automatically via a script and it run unattended.

In my testing I am able to send an email via Outlook from the macro, however it requires an answer to a deny or allow prompt.  How can I get the email sent without manual intervention?
0
motherm
Asked:
motherm
1 Solution
 
Dale FyeCommented:
I use a third party application called vbMAPI.  Don't remember how much it cost, but it was reasonable.  There is also the CDO method, but I've never used it.
0
 
Eric ShermanAccountant/DeveloperCommented:
I've used Outlook Redemption with much success to eliminate that problem.

http://www.dimastr.com/redemption/download.htm

ET
0
 
mothermAuthor Commented:
Is there any way to send email from access without a third party?  My employer will not support any downloads or additional apps.
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
Eric ShermanAccountant/DeveloperCommented:
<<<Is there any way to send email from access without a third party?  My employer will not support any downloads or additional apps.>>>

When I dealt with this issue a while back ... Outlook will not let you dump emails into it without flagging each one ... It thinks this is SPAM.  Therefore, your options or to use a third party application, CDO Method or the Outlook Redemption option to bypass the security prompt.

ET
0
 
efrimpolCommented:
Free for commercial or non-commercial use.

https://www.mapilab.com/outlook/security/
0
 
Helen FeddemaCommented:
The obnoxious Object Model Guardian appears to have been revived with a recent update.  See my article on using the Redemption Library to avoid it.
accarch113.zip
0
 
mothermAuthor Commented:
Thank you for the solution.
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now