PDA

View Full Version : Verifying emails have been sent



hk129
07-15-2015, 09:50 AM
Hello, I am trying to create a program that automates emails being sent from Excel. I have a column titled "Email Sent" which would have the value "Yes" if an email has been sent to the recipient. I would like a way to populate this column to "Yes" if the email did reach the recipient's inbox. I was looking at ways to do this using the command .OriginatorDeliveryReportRequested = True but I'm having a hard time trying to get it to work. Can anyone help me out?

Kenneth Hobs
07-16-2015, 05:59 AM
I guess you would first need to get all of the emails in your Outlook inbox and check the subject line. To start off, see: http://www.exceltip.com/applications-word-outlook-in-vba/control-outlook-from-excel-using-vba-in-microsoft-excel.html