Need a windows powershell code to get a report of all delivered emails

I am trying to send reminder mails all customers with outstanding balance. To automate that I have created a powershell code which read email IDs and balance amounts from an excel and send email notifications to them. This is already achieved.

My next requirement is to include a code in that script or in any other way by which I get a report of which all mails are delivered to the recipient and then we can see which recipient has read their mail.
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

MacleanSystem EngineerCommented:
2nd part of requirement is highly unreliable. To see if a recipient read their email you need to assume that

1] Everyone acknowledges read receipts
2] No one has auto read receipts enabled, to avoid marking unread mails as read by accident when mouse clicks on the mail in inbox.

You might as well focus on delivery receipts and do away with the second part.
I found the below bit of code here, but I cannot guarantee that this works, as I have not tested it.

Get-ExchangeServer | where {$_.IsHubTransportServer -eq “true”} | Get-MessageTrackingLog -EventId “RECEIVE” | select TimeStamp,Sender,{$_.recipients},MessageSubject | Export-Csv C:\undergraduatestudents.csv

Open in new window

If you really want the second part, I'd refer to this article here to take the bits you want from the code and trial it.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.