Excel 2000 / send email to a group

[Abay]

Hello ... I have hundreds of excel spreadsheets that need to be sent to
different individuals .. i.e. each file goes to a different recipient.

I know how to create a macro to send an individual file to a recipient ...
don't have the skill to figure out how to have a macro open each file & then
execute a macro (or it may be done in one macro) to send the spreadsheet to
the appropirate recipient .. I think it can be done by putting the file
names in a list, after that I'm lost.

As far as I can see once the file has been sent and saved the email address
is also saved, so after the first time the email address appears as soon as
the "send to" option is chosen for each file.

Any help on this would be most appreciated

bay

 

[Ron de Bruin]

Hi Abay

Maybe this is a option
http://www.rondebruin.nl/mail/folder2/files.htm

 

[Abay]

Thank you so much for the info .. it worked like a charm, yippee, what a lot
of work it saves!

Abay