Help with Excel email macro

[handclips]

hihi


I'm trying to pull a list of all email subjects from a folder in Outlook base on date/timestamp into


For example, I want to extract all emails received after 22 Aug 2022, 1pm in Inbox - Purchases folder into Excel.


Is there any way to do it?


I tried using the link before but encountered "User-defined type not defined" error on the first row.

How To Import Your Outlook Emails Into Excel With VBA | How To Excel

www.howtoexcel.org

 

[Fluff]

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Help with Excel email macro
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[handclips]

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Help with Excel email macro
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

My apologies, i reposted with slightly different content as the other forum does not allow me to include external links

I wanted to give an example of the codes that I've tried and failed