export mails to excel report

[Edgar5155]

Hi Dear Experts, Hope all of doing safe and sound!


well, I'm having a serious case that I'm getting lots of mails from various clients and I need to find a way to filter a a specific client mails and export them to excel report with defined criteria.


so I will be pleased if someone can help me. i'm using outlook 2016


I want to go through all mails at specific inbox, then target mails with specific sender. then define the duration period for target mail (for ex. from 10 jan to 15 jan 2021)


all mails subjects will be as following:

New :: [#85236951] New Task Proposal COVID – EN-US :: WO42633 :: New Work Request :: Matrix Medical Network

I need to export those subjects as exited on excel sheet attached.

Sample.jpg

I will be so much appreciated if some one can help me about this.

Cheers


cross-Posting link: https://www.excelforum.com/outlook-p...ter-mails.html