Send To Email recipient one sheet from workbook
 

I have a workbook with several worksheets in it. I would like to know if
there is a way to send via email a copy of just one of the worksheets (the
active one)? When I use the Send To option from the File drop down menu it
sends the whole workbook. I know I can copy the worksheet to a new blank
workbook and then send but I am thinking there has got to be a way of doing
it from within the original workbook.

Send To Email recipient one sheet from workbook
 

Hi Doug

If you want it as a attachment you can use a macro or use my SendMail add-in
http://www.rondebruin.nl/sendmail.htm



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Doug" wrote in message ...
I have a workbook with several worksheets in it. I would like to know if
there is a way to send via email a copy of just one of the worksheets (the
active one)? When I use the Send To option from the File drop down menu it
sends the whole workbook. I know I can copy the worksheet to a new blank
workbook and then send but I am thinking there has got to be a way of doing
it from within the original workbook.