Excel and e-mail

[Maria Baptiste]

Help!

Is there a way to e-mail a single excel sheet and not the entire workbook? I
have students grades in a workbook and need to e-mail weekly updates. When
I try. The entire workbook is sent even though only one tab is highlighted.

Is there anyone who can help me?

Maria

 

[Shane]

I am no expert in Excel, as perhaps can be inferred from my recent
posting. However, it seems to me that one solution to your problem
would be to save the document using a different filename, edit it to
remove any sheets that you do not want to send, save the document under
the new filename, and then e-mail that in your weekly update. I know
that this is cumbersome, and perhaps someone else can provide a better
answer, but at least it is a temporary solution.

Also, I noticed that when you sought to include some extra information
in your query, you started a new topic. Though I am new to the group,
and without meaning to sound rude, I imagine that it would be better to
keep all information about a specific query within the same topic, so
that everything is in one place. You should be able to do this on the
website by clicking on your message and then clicking on reply at the
bottom.

I hope that at least some of this is helpful.

 

[JE McGimpsey]

I am no expert in Excel, as perhaps can be inferred from my recent
posting. However, it seems to me that one solution to your problem
would be to save the document using a different filename, edit it to
remove any sheets that you do not want to send, save the document under
the new filename, and then e-mail that in your weekly update. I know
that this is cumbersome, and perhaps someone else can provide a better
answer, but at least it is a temporary solution

Shane's hit the nail squarely on the head - you can only send Workbooks,
not worksheets, so you must copy the sheet to a new workbook before you
send.

One small refinement of Shane's method would be to copy just the active
worksheet to a new workbook, by CTRL- or right-clicking the worksheet
tab and choosing Move or Copy from the pop-up menu. In the Move or Copy
dialog, choose "new workbook" from the "To book:" dropdown, and check
the "Create a copy" checkbox.

This can be automated using a macro:

http://www.mcgimpsey.com/macoffice/excel/macexcelsendmail.html

Note that, if your single worksheet has links to other sheets that those
links will be in your copy, too.

 

[Socrates]

If the recipient will only VIEW the spreadsheet, you're better off
commanding a print job and create a pdf, which will be only one sheet
of the book. Then email the pdf.

 

[Socrates]

If the recipient will only VIEW the spreadsheet, you're better off
commanding a print job and create a pdf, which will be only one sheet
of the book. Then email the pdf.

 

[Socrates]

If the recipient will only VIEW the spreadsheet, you're better off
commanding a print job and create a pdf, which will be only one sheet
of the book. Then email the pdf.

 

[Maria Baptiste]

Thank you. That is a good idea. I will try all solutions and see which
works most efficiently.


Maria

 

[Shane]

Shane and JE,

Thank you so much for your help. Do you think it then makes better
sense to
have one workbook per student?

Maria


I think that McGimpsey would be better able to provide you with an
answer than me, but I'll give you my thoughts.

It seems that the simplest thing to do would be to have one workbook
per student. This saves you wasting time creating a new workbook each
time you want to send an update. The disadvantage of this seems to be
that then all your information is in a variety of documents.

The second option is to have an all-encompassing workbook, which you
seem to have already, and then to make a copy of worksheets that you
wish to e-mail. This seems to have the advantage of having all
information in one document, and if you use a macro as Mr McGimpsey
suggests, then it will not be too much hassle to create a new workbook
for each worksheet each time. If you have not used macros before, they
are quite easy to learn use. The easiest way is to click on "Tools",
then "Macro", then "Record New Macro..." After you give the macro a
name, and, if you want, a shortcut, then all you do is perform the
operation you want it to do, and click the square stop button. It's
like recording what you want to happen. If you are willing to take the
time to do this, I think it will be rewarding in the long run. This is
the option I would pick, but then I can already use macros.

Another option would be to use links. In the same way that cells can
refer to other cells in the same worksheet, to sum them or average them
for example, cells can refer to cells in other workbooks. If, for
example, you want the cell B3 in Workbook2 to be the same as the cell
C5 in Workbook2, type "=[workbook1.xls]Sheet1!C5" in cell B3. This way
you could have a main workbook, and have others, ready to send, that
automatically update. I haven't found a way to make this much use for
what you want though.

I hope that this helps. I think that the problem is that designers,
and programmers especially, often fail to think how people are likely
to use something. It seems that instead of programs that work around
humans, humans are expected to work around programs.