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?
mothermAsked:
Who is Participating?
 
Eric ShermanConnect With a Mentor Accountant/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
 
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
Cloud Class® Course: Microsoft Windows 7 Basic

This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.

 
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
 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.