Emailing Spreadsheet

  • Thread starter Thread starter Karen
  • Start date Start date
K

Karen

I have a spreadsheet that I update daily and email to various
employees. When I click on the email icon within Excel it brings up a
To: Cc:, etc type setup. I am able to choose from my address book and
send from Excel. This is so cool. However, when it is received and
printed, it prints lots of blank pages. When I print from my station,
I am able to set the print area, but when it is emailed that isn't an
option. Is there someway to set the emailed area? Thanks.

Rosy
 
When you email sheet contents as the message text (which I think you're
doing as opposed to emailing the worksheet as an attachment), Excel seems to
send the entire active area of the sheet. This is the range you go to by
pressing Ctrl-End. If this range is beyond the range of actual data you
should select the unneeded rows and delete them (Edit, Delete) and then do
the same for the extra columns, if any. Then save the workbook. At this
point Ctrl-End should take you to the end of real data and this is the range
that will be emailed.

If however you just want to email a portion of the data on a worksheet I
think you have to copy/paste that data to a new (temporary) sheet and email
that.


--
Jim Rech
Excel MVP
|I have a spreadsheet that I update daily and email to various
| employees. When I click on the email icon within Excel it brings up a
| To: Cc:, etc type setup. I am able to choose from my address book and
| send from Excel. This is so cool. However, when it is received and
| printed, it prints lots of blank pages. When I print from my station,
| I am able to set the print area, but when it is emailed that isn't an
| option. Is there someway to set the emailed area? Thanks.
|
| Rosy
 
Back
Top