asked on

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

Jacques Geday

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

rogerdjr

ASKER

Yes the macro is

ExportEmailContentToExcel

Currently I run it from the excel sheet

Thanks

Jacques Geday

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

rogerdjr

ASKER

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

Jacques Geday

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

rogerdjr

ASKER

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

Jacques Geday

Sorry was caught in urgent matters will look at this one asap
Tks your patience.

gowflow

rogerdjr

ASKER

no problem

Let me know if you need more info - I am still hoping to find a solution

Jacques Geday

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

ASKER CERTIFIED SOLUTION

Jacques Geday

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

rogerdjr

ASKER

Thanks for your hard work - works great

Jacques Geday

ok great glad I could help

gowflow