There are a few ways
Install one of the templates in the file
http://www.rondebruin.nl/mail/templates.htm
Or if you have the mail address in each worksheet you can use
http://www.rondebruin.nl/mail/folder1/mail5.htm
Or
http://www.rondebruin.nl/mail/folder2/mail5.htm
If you want to create first seperate workbooks see
http://www.rondebruin.nl/copy6.htm
And then you can use this macro to mail
http://www.rondebruin.nl/mail/folder2/files.htm
--
Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm
"MY" wrote in message ...
I have a file with 200 sheets for different sales people. I want to send them
their sheet only and want to copy the sheets into their own files. Any help
would be appreciated.