How do you email one worksheet from a 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?

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?

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?