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

2 Answered Questions

[SOLVED] Moving Emails in Outlook Folders to Subfolder with VBA?

  • 2019-08-19 13:48:19
  • Santya
  • 293 View
  • 0 Score
  • 2 Answer
  • Tags:   excel vba outlook

15 Answered Questions

[SOLVED] How to avoid using Select in Excel VBA

  • 2012-05-23 05:57:58
  • BiGXERO
  • 280926 View
  • 537 Score
  • 15 Answer
  • Tags:   excel vba

1 Answered Questions

Extract Email Data from Outlook Folder

2 Answered Questions

[SOLVED] Download attachment from Outlook and Open in Excel

2 Answered Questions

1 Answered Questions

1 Answered Questions

export email from outlook

  • 2018-11-18 07:27:38
  • Богдан Шишов
  • 104 View
  • 0 Score
  • 1 Answer
  • Tags:   excel vba outlook export

1 Answered Questions

1 Answered Questions

[SOLVED] Excel VBA for searching in mails of Outlook

Sponsored Content