send 1 sheet of a workbook in email - Excel 07

K

Kim K

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!
 
D

D Hilberg

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
 
B

Bruce Sinclair

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:
Click to expand...

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
Click to expand...
 
D

D Hilberg

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
 
F

Francois via OfficeKB.com

Kim said:
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!
Click to expand...


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
 
K

Kim K

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 said:
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
Click to expand...
 
K

Kim K

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 said:
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
Click to expand...
 
C

challa prabhu

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
 
K

Kim K

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.
 
K

Kim K

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!
 
Top