Send To Email recipient one sheet from workbook

[Doug]

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.

 

[Ron de Bruin]

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