MrExcel Publishing
Your One Stop for Excel Tips & Solutions

E-mailing a Worksheet.


Posted by Mike on November 19, 2001 4:58 AM

In Excel 97, is it possible to e-mail a specifc
worksheet from a workbook, or is this function not
avail?

Thanks,
Mike


Posted by Maureen Hill on November 19, 2001 5:09 AM

I'm not sure about Excel 97, but in Excel 2000 you can send the active sheet of the current workbook if you're using Outlook. (If you're sending only the current sheet, it appears as the body of the e-mail message, not as an attachment.)

Other than that, I guess you could copy the sheet you want to send into a new workbook and send that workbook.

Hope this helps.

Posted by Mike on November 19, 2001 5:16 AM

* * * *

Juan,
Thanks. I've been copying the workbook to a new file and the deleting what I don't want, then sending that. A pita. Lotus let's you do it.
I think it might be time to get Excel 2000.

Thanks