I have a batch of files for different customer, always called by the customer
name, but the contents of each file changes, and they are always saved in the
same folder.

I would like to email these files to my customers, automatically.

In another spreadsheet, I have the file (company) name in column A, and the
email address (es) in column B and / or C etc.

I would like some kind of macro, to look in column A for the company name,
which will be the file name, and go to the file always saved in the same
directory, attached it to an email, and email it to the address (es) in
column B, C etc.

This is to prevent having tio email all the files manually.

Using Excel 2003 and Outlook 2003.

Any help / guidance is aprpeciated.

Thank you
Richard