By Carlos Martin De los Santos Ng


2014-10-22 13:32:35 8 Comments

I have several emails sent to me on a daily basis or every 15 days, I need to keep track that they are being delivered on time.

I have created rules on Outlook for them to be stored on different folders and subfolders.

What I'd like to do is have an Excel Sheet that compares Objective Date/Time Vs Actual Date/Time delivery. For this I need to extract the Sent Time and Date from Outlook and Export it to Excel. I'm not sure if to do it based on Folder/Subfolder name or Pieces of Subject, as it is done for my rules.

I have read the answer of similar questions but have not being able to adjust it to my needs.

1 comments

@Eric Legault 2014-10-22 14:55:41

I would create a Search Folder that indexes the specific folders containing these emails. Then loop through Folder.Items for that Search Folder to extract the properties you need from each MailItem in the Items collection.

Related Questions

Sponsored Content

1 Answered Questions

Extract Email Data from Outlook Folder

2 Answered Questions

[SOLVED] Download attachment from Outlook and Open in Excel

0 Answered Questions

Outlook VBA - Save Excel file with email subject

2 Answered Questions

1 Answered Questions

1 Answered Questions

export email from outlook

2 Answered Questions

[SOLVED] Reference Outlook folder from Excel

1 Answered Questions

1 Answered Questions

[SOLVED] Excel VBA for searching in mails of Outlook

2 Answered Questions

[SOLVED] How to call VBA code from Outlook then VBA code from Excel?

Sponsored Content