email one sheet within a workbook

  • Thread starter Thread starter Kay Faulkner
  • Start date Start date
K

Kay Faulkner

How do I email only one worksheet within a work book via
email?

Help greatly appreciated
Thanks
Kay
 
Kay Faulkner said:
How do I email only one worksheet within a work book via
email?

Help greatly appreciated
Thanks
Kay
Click to expand...

I think you can only do this by copying the worksheet to another workbook
and emailing that new workbook.
 
Here is one way.

Right click on the name of the sheet at the bottom.
Select 'move or copy'.
Under 'To Book' select '(new book)'.
Check the box 'create a copy'.
OK.

You will have a new workbook (book2 etc) with just that
worksheet.
Now do file > send to mail recipient as attachment.

It will create an email for you with the attached message.
Send that out.

Then close down the new book (book2 etc) that you created.

Allen
 
Back
Top