Hi GMayor,
To start, Thank you so much.
The file content will look like what you sent.
Results can be in CSV format
1) File names are different for each:
Example would be:
RK195799
RK195845
RK195878
One file comes in each night.
2) No Possibility for duplicate file names


3) I set up a rule in outlook to take the files that come in and send them to a folder on the network. I attached a screen shot so you can see it.
4) How would I set it up to incorporate the extraction process into my macro?
Here is where the master file lives.
5) Const strMasterPath As String = "\\fngn.com\us\Projects\Print Production\Reports\DSG Drop reports\Master.csv"
'The full name of the master csv
6) Do you see any issues with the path?

Attached Images

Rule in Outlook.JPG (58.7 KB, 25 views)