Extract text under a string from EML files

[excelknuckles]

Hi everyone!

I consider myself a moderately skilled Excel user, but this one is beyond me. I have no experience with VBA.

I have hundreds of .eml files that all follow generally the same format:

[Date in YYYY-MM-DD]

1. Inputs

[Data]

2. Search Results

Joe's Tacos - showed up 11 times
John's Pizza - showed up 2 times

What I would love to do is to bulk extract the data from all of these .eml files under the "2. Search Results" heading to result in the following sheet:

Date	Store	# of results
[Date from top of .eml]	Joe's Tacos	11
[Date from top of .eml]	John's Pizza	2

If anyone could please assist, I would be exceptionally grateful.