K Kay Faulkner Sep 12, 2003 #1 How do I email only one worksheet within a work book via email? Help greatly appreciated Thanks Kay
A Anon Sep 12, 2003 #2 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.
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.
A Allen Sep 12, 2003 #3 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
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
