E-mail Portion of Spreadsheet

  • Thread starter Thread starter Sally
  • Start date Start date
S

Sally

I have an Excel spreadsheet that I have to e-mail to co-
workers everyday. I don't want to e-mail it as an
attachment. I want it inserted into the body of the e-
mail. I will be adding a few rows to the speadsheet each
day. The catch is, I only want to send the entries for
that day and I also have to send the column headings.
For example:
Column headings in A1:L2
Rows to send for today in A6:L8

At first I thought a good way of doing this would be to
open the spreadsheet in Excel, go to File > Send To >
Mail Recipient and then just delete the rows I don't
need. But that would alter the file itself. Does anyone
know of a better way to do this?

HELP!
 
I also forgot to mention that if I copy & paste, all of
the format on my spreadsheet is lost. So I can't do that
By the way - I'm using Office 2000
 
the BEST way of doing this is to use Lotus 123! That allows you to send part
of a sheet by email.
Unfortunately the best way of doing this in Excel AFAIK is to copy the
portion of the sheet you want to send into a new workbook and then send
that.
Not sure you CAN insert a sheet into an email anyway.... I've never seen
that done, it's always an attachment.

HTH
 
Thank you for your help - Yes, all my users are using
Outlook. How do I switch to RTF formatted mail?
Thank you again
 
Back
Top