ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Excel Workbook (https://www.excelbanter.com/excel-worksheet-functions/93616-excel-workbook.html)

Toothpick

Excel Workbook
 
How do you email one worksheet from a workbook?

Roger Govier

Excel Workbook
 
Hi

If you need to send it as an attachment (as opposed to within the body
of the message) then you need to copy the sheet to a new workbook first.
Right click on Sheet tabMove or CopyClick Create CopyTo book(new
book) as destination then save this workbook.
FileSend ToMail Recipient(as attachment)

--
Regards

Roger Govier


"Toothpick" wrote in message
...
How do you email one worksheet from a workbook?




Toothpick

Excel Workbook
 
Thanks Roger! That was a great help!

"Roger Govier" wrote:

Hi

If you need to send it as an attachment (as opposed to within the body
of the message) then you need to copy the sheet to a new workbook first.
Right click on Sheet tabMove or CopyClick Create CopyTo book(new
book) as destination then save this workbook.
FileSend ToMail Recipient(as attachment)

--
Regards

Roger Govier


"Toothpick" wrote in message
...
How do you email one worksheet from a workbook?





Alien

Excel Workbook
 
Unlike the old version the only "send" option in the 2007 is "fax". I did an
"add-in" for email but can't get a screen for sending.--
thanks for any help! of all the earlier verisions (as well as Outlook) this
is the most frustrateing!
Alien


"Toothpick" wrote:

How do you email one worksheet from a workbook?



All times are GMT +1. The time now is 04:42 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com