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?