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.