Solved

Send email from MS Access macro

Posted on 2016-10-26
7
60 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

 
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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
In earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database.  This article shows how to recreate this functionality in Windows 7 through 10.
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

733 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