Hi All,

I am seeking code sample or tips to help with the following:

Workbook 1 contains a organization and email addresses for the organization.


Workbook2 contains a separate worksheet (worksheet name would be AF, Baghdad, etc) for each organization and I have a folder on my desktop that contains files (file names would be AF.xls, Baghdad.xls, etc) for each organization.

What I am trying to do is send an email to each address in workbook 1 that contains the worksheet or file for that organization - file name or worksheet name matches the org name in workbook 1.