To Multiple Excel Files
 

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.

To Multiple Excel Files
 

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



--
Regards Ron de Bruin
http://www.rondebruin.nl


"sobh" wrote in message ...
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.