Import Outlook 2013 Email (Delivery / Read Receipt) to excel

I have a macro that imports emails to a spreadsheet, and captures key field data for reference

When the macro imports a Read Receipt or a Delivery Receipt it does not import the associated sent to / sent from information

What I am trying to do is compile a table in excel of all the emails distributed and who received them, who read them and who had an undeliverable email address using excel.

Spreadsheet is attached with macro
J--Personal-Computer-VBA-Import-Ema.xlsm
rogerdjrAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
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.

gowflowCommented:
I see this question has been neglected and posted since 2 days now without any appearent answer.

Is the macro you are talking about is: ExportEmailContentToExcel ?
Are you still interested in getting a solution ?

Rgds/gowflow
rogerdjrAuthor Commented:
Yes the macro is

ExportEmailContentToExcel

Currently I run it from the excel sheet

Thanks
gowflowCommented:
What is the field that you are missing I see in the macro that they are all there. What is the situation that is not importing that field ?
gowflow
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

rogerdjrAuthor Commented:
I am looking for the sender's email address for the delivery receipt and read receipt.

Works fine giving me the sent to email address and received from email address for emails but does not seen to work for delivery receipt and read receipt
gowflowCommented:
Can you pls post 1 or 2 delivery receipt or read receipt (save the email as .msg) and post it here and I will check it I never use these delivery receipt as believe it is annoying to have someone acknowledge they have received the email but that is my opinion.

gowflow
rogerdjrAuthor Commented:
See attached zip file with a couple of successful delivery receipts and a delivery failure.

I agree about read receipt and use it a lot less often

I use the mail merge often to distribute contract documents and wand an easy way to evaluate who did not receive the required info

Thanks a lot for your help
C--Users-Roger-OneDrive-Documents-De.zip
gowflowCommented:
Sorry was caught in urgent matters will look at this one asap
Tks your patience.

gowflow
rogerdjrAuthor Commented:
no problem

Let me know if you need more info - I am still hoping to find a solution
gowflowCommented:
No info needed am actually working on it right now and you are correct it does not pick up these items looking for alternatives will shortly revert. Sorry this one have really taken time as could not devote time on it now that I am on it will hopefully get to the bottom of it. Don't be discouraged saw you posted a request for attention.

gowflow
gowflowCommented:
I have been working extensively on this all weekend and to shed some lights the Read/Delivery items are not Mailitems but rather ReportItem and here is the trick in reportitem you can't get the properties you have in MailItem which brings you to have to use Hexdecimals to retrieve them I was not able to have the properties to my satisfaction but please try this version and I would appreciate you advise if it is not to your taste what would be the fields value that are missing for the delivery mails you posted so I can check further on this and see a way thru.

Rgds/gowflow
J--Personal-Computer-V01.xlsm

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
rogerdjrAuthor Commented:
Thanks for your hard work - works great
gowflowCommented:
ok great glad I could help

gowflow
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
Microsoft Excel

From novice to tech pro — start learning today.