Solved

Send email from MS Access macro

Posted on 2016-10-26
7
45 Views
Last Modified: 2016-11-10
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
Comment
Question by:motherm
7 Comments
 
LVL 47

Expert Comment

by:Dale Fye (Access MVP)
ID: 41860798
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
 
LVL 19

Expert Comment

by:Eric Sherman
ID: 41860954
I've used Outlook Redemption with much success to eliminate that problem.

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

ET
0
 

Author Comment

by:motherm
ID: 41860998
Is there any way to send email from access without a third party?  My employer will not support any downloads or additional apps.
0
Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

 
LVL 19

Accepted Solution

by:
Eric Sherman earned 500 total points
ID: 41861052
<<<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
 
LVL 6

Expert Comment

by:efrimpol
ID: 41861189
Free for commercial or non-commercial use.

https://www.mapilab.com/outlook/security/
0
 
LVL 31

Expert Comment

by:Helen_Feddema
ID: 41863922
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
 

Author Closing Comment

by:motherm
ID: 41882663
Thank you for the solution.
0

Featured Post

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question