To Multiple Excel Files

[Guest]

Hi All,

I am having a excel file of diff product sold by salesmen. Now my
requirement is, i need to save the sales done by each person in seperate
excel file , with salesmen name,and need to mail them. I am having nearly
200 salesmen in the report.

Can any one help me in this case.

 

[Ron de Bruin]

Hi sobh

Start here
Use the workbook option to create a new workbook for each Salesmen
http://www.rondebruin.nl/copy5.htm

You can create a list then in a workbook with the names and file names to send the mails
See
http://www.rondebruin.nl/mail/folder2/files.htm