We help IT Professionals succeed at work.

Access/Outlook 2016 - enabling tracking options for messages sent via EmailDatabaseObject/SendObject commands

Running WinServ2012R2 with Access and Outlook 2016.

Using job scheduler and macros/VBA to send out automated reports via email.  Messages are going out fine....but now I want to see who's actually reading them and who's ignoring them.

Outlook profile on the machine has read-receipt-requested as a default.  Access is sending the messages out via EmailDatabaseObject and/or SendObject....and it's not picking up that profile setting.  Instead, the sent messages have the tracking options (delivery/read receipt) greyed out.

Any way to fix/enable it?  If not, we'll live....but it would have been nice.  

The Access/Outlook "break" might even be by design.  I noticed that Access macros will still run even if Outlook is NOT open.  The messages will just queue up in the Outbox and will go out whenever Outlook gets re-opened.
Comment
Watch Question

Daniel PineaultPresident / Owner CARDA Consultants Inc.
CERTIFIED EXPERT
Distinguished Expert 2018

Commented:
Eye EssThe IS Department

Author

Commented:
Possibility....but that looks like it'd also require rewriting quite a bit of the macros......

I was hoping to retain the use of EmailDatabaseObject in the existing macros....or SendObject in the VBAs.   In looking at the link, I suspect we'd have to revamp it all to create the MailItem, attach the report objects (usually PDF or XLSX) and that sort of thing....

Thanks for the response.
John TsioumprisSoftware & Systems Engineer
CERTIFIED EXPERT
Distinguished Expert 2019

Commented:
Another way would be to use the CDO and get "free" from Outlook
https://gallery.technet.microsoft.com/scriptcenter/1a7ba743-30e2-430e-99a4-9310396f99ef
Eye EssThe IS Department

Author

Commented:
OK, so that's another rescripting option.....cool.....thanks.
Jim Dettman (EE MVE)President / Owner
CERTIFIED EXPERT
Fellow
Most Valuable Expert 2017

Commented:
Before you go through too much trouble, be aware that while you can request a read receipt, it's up to the receiving end to actually return one.  Typically, read receipts are turned off (or prompted for) by default as to not return a read receipt on spam e-mails.

So you really can't count on knowing if someone has read an e-mail or not.

Jim.   
Eye EssThe IS Department

Author

Commented:
Good point.....though I'd hope our user community would have the sense to respond to an internal email from an administrative account.  :)



Appreciate the feedback.....
The IS Department
Commented:
I think I'll close this one out - while the rescripting options are viable, the users can in fact *not* allow the read-receipt to go through.....

Thanks to all for their input.
Eye EssThe IS Department

Author

Commented:
Thanks for the input.........

Explore More ContentExplore courses, solutions, and other research materials related to this topic.