Lookup Email Address in Excel File and Mail that file to that Email

[Kevin916]

I have followed Mr Excel's tutorials and have been able to create 481 unique files from a large master spreadsheet. Now I want to write some VBA code to look in that directory, look at a specific cell in each file, find the email address, and then email that specific file to the person using Outlook.

I've seen a lot on this board about selecting a range within an open Excel ss and emailing that range. I want to send each unique file to each unique sales person. Any thoughts on the VBA code to do it? Talking Excel 2007 (W7 platform)