To Book = (new book) [which is the top choice, sometimes obscured] - LOL -
does this include PRE coffee moments early in the morning? Yes I saw that
AFTER I sent the other response.
--
Thanks,,
Kim


"D Hilberg" wrote:

I don't know of a non-programmatic way to easily send only one sheet.

You can, of course, create a temporary workbook with only that sheet,
mail it, and close without saving:

Edit Move or Copy Sheet
Check box: "Create a Copy"
To Book = (new book) [which is the top choice, sometimes obscured]

File Send To Mail Recipient (as attachment)

I have run across macro code that allows you to send a sheet to a pre-
designated recipient. Perhaps someone has code that allows the
recipient to be specified at the time of mailing (assuming that is
what you want, and you're willing to install it).

- David



On Jul 9, 8:06 pm, Kim K wrote:
There has got to be an easy way for my staff to send one sheet of a workbook
via email. I have read thru pages of web sites but not found anything easy
to use or do.

Any suggestions for my staff welcome!
--
Thanks,,
Kim