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

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

In article . com, 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:

Note ... it is MUCH safer to do this the other way around ...
1) save as (say) "Temp_emailsheet.xls"
2) delete all the other sheets
3) Send that sheet

This method will ensure that you don't save the single sheet over your
original ... which only has to happen once to be a real pain. :)

(snip)

- 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

In my previous post, I should have mentioned that sending one sheet is
an option that may be available if you have installed other Microsoft
products (Online Help is vague, but mentions Outlook and Microsoft
Exchange Server.) I don't use these, so I don't see the option.

- 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

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!


What E Mail System do you use?

Check out Ron De Bruins site I did and I'm very happy with the result, I
use Lotus Notes, but other examples are available

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200707/1

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

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

Hi,

Send a workbook or worksheet as a message in e-mail


1. Open the workbook you want to send.
2. If you want to send specific cells on a worksheet, select the cells you
want to send.

A. On the File menu, point to Send To, and then click Mail Recipient.

B. If prompted whether to send the entire workbook or just the current
sheet, click Send the current sheet as the message body.

3. In the To and Cc boxes, enter recipient names, separated by semicolons.
4. If you want to verify names you've typed against your address book, click
Check Names .
5. Type a subject in the Subject box.
6. If you are sending Microsoft Excel data as a message, you can include
explanatory text. Type your text in the Introduction box.
7. If Microsoft Outlook is your mail program, you can customize the message.

Challa Prabhu

"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

Thank you for your reply, yes you are correct this is an option in Office
2003, but not in 2007, which is my problem. 07 only allows for the entire
workbook to be sent to a mail reciepient.
--
Thanks,,
Kim


"challa prabhu" wrote:

Hi,

Send a workbook or worksheet as a message in e-mail


1. Open the workbook you want to send.
2. If you want to send specific cells on a worksheet, select the cells you
want to send.

A. On the File menu, point to Send To, and then click Mail Recipient.

B. If prompted whether to send the entire workbook or just the current
sheet, click Send the current sheet as the message body.

3. In the To and Cc boxes, enter recipient names, separated by semicolons.
4. If you want to verify names you've typed against your address book, click
Check Names .
5. Type a subject in the Subject box.
6. If you are sending Microsoft Excel data as a message, you can include
explanatory text. Type your text in the Introduction box.
7. If Microsoft Outlook is your mail program, you can customize the message.

Challa Prabhu

"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

we use Outlook exchange 03. I have been to ROn's site and the only option
there for my staff is to use the addin, but I have not been successful at
that yet this morning!
--
Thanks,,
Kim


"Francois via OfficeKB.com" wrote:

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!


What E Mail System do you use?

Check out Ron De Bruins site I did and I'm very happy with the result, I
use Lotus Notes, but other examples are available

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200707/1

07 only allows for the entire
workbook to be sent to a mail reciepient.

Not True

You can add this option to the QAT if you want
Read how on this page
http://www.rondebruin.nl/0307commands.htm


The name is "Send to Mail Recipient"
Search for it in the commands that are not in the ribbon list




--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Kim K" wrote in message ...
Thank you for your reply, yes you are correct this is an option in Office
2003, but not in 2007, which is my problem. 07 only allows for the entire
workbook to be sent to a mail reciepient.
--
Thanks,,
Kim


"challa prabhu" wrote:

Hi,

Send a workbook or worksheet as a message in e-mail


1. Open the workbook you want to send.
2. If you want to send specific cells on a worksheet, select the cells you
want to send.

A. On the File menu, point to Send To, and then click Mail Recipient.

B. If prompted whether to send the entire workbook or just the current
sheet, click Send the current sheet as the message body.

3. In the To and Cc boxes, enter recipient names, separated by semicolons.
4. If you want to verify names you've typed against your address book, click
Check Names .
5. Type a subject in the Subject box.
6. If you are sending Microsoft Excel data as a message, you can include
explanatory text. Type your text in the Introduction box.
7. If Microsoft Outlook is your mail program, you can customize the message.

Challa Prabhu

"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