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.

 

[bobaol]

Hello excelknuckles, it sounds like you need to do the following: 1. open the .eml file, 2. copy all 3. paste as text into Excel. 4. manipulate the text in excel so you can get a summary of the data. For parts 1, 2, and 3, i would use MacroExpress, or Keyboard Maestro for these type of manual work. There could be other ways around it, but MacroExpress has saved me many times. Easy to learn and use. Once you have the data in Excel, you can do all that manipulation with your Excel skills. Cheers!