If this is a one timer just copy each sheet to a new workbook and send the
workbook
If this will happen quite often you can download an add-in by Ron De Bruin

http://www.rondebruin.nl/mail/add-in.htm



--
Regards,

Peo Sjoblom



"Cher" wrote in message
...
I have an Excel document with four worksheets and need to send each one as
an
email. How do I make each worksheet into its own document?