Check if Outlook email is sent out cancelled by user
Competent Performer
Windows 10 
Access 2013 32bit
I have automated Outlook via Access to send email reminders. Currently in the VBA I have code just to display the emails to send and not to send automatically, just for debugging at this stage. However, if I chose not to send the emails, when I run the email code again my emails are not showing so Access thinks I have sent the emails even though they are not in my sent folder in Outlook.
Virtually Inert Person
Windows 10 Access 2016
You would have to loop through the sent items folder to see if the email you think should be there does exist. Or use the method posted here:
https://www.mrexcel.com/board/thread...3/page-2#posts
Once testing is over and the email is automatically sent, won't this become a non-issue?
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
Competent Performer
Windows 10 Access 2013 32bit
Thanks for the quick response. I agree once testing is over this won't be an issue, but just looking for failsafes I guess.
Access 2010 Send Outlook Email from Button Click - Failing to send email unless Outlook is open.
adding current user to CC line of outlook email
Add Signature to Outlook Email - (Signature in User File!) - IDEA Combine MEMO
Posting Permissions
Reply With Quote