in 07 all this does is to copy a new sheet into the current workbook, the
only way I have found to do this is to either copy all pertinant info into a
new emal (which looses its formatting in some email programs, or to copy into
a whole new spreadsheet then send to mail reciep.

I found Ron's page but my users will not be able to do the code - most the
things thay have are pre existing workbooks, and if I could get teh addin to
work that could do it buit I have not been successful yet.
--
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