Is there a way to send a single worksheet?

[Tana Reiff]

I understand how to attach an Excel file to e-mail from the File menu
in Excel. Is there a way to send just one worksheet, not the whole
file? Or would I need to create new separate files?

 

[Jim Gordon MVP]

Hi Tana,

You need to create a separate file first, but that is usually easy to do by
using Edit > Move or Copy Sheet and in the drop down box choose to make a
new workbook. You can immediate use File > Send To with the new workbook.

-Jim
--
Jim Gordon
Mac MVP

MVPs are not Microsoft Employees
MVP info

 

[genrluse]

Jim

Excel for Windows has the very useful feature that enables you to
e-mail an individual worksheet from within a workbook. This is very
useful for instructors who maintain their student grades in individual
worksheets in a workbook. Each week the individual worksheets can be
e-mailed to the students without having to open a new workbook each
time.

Any chance of getting this feature into Excel for Mac?
Thanks

Regards,

Rick

 

[JE McGimpsey]

Any chance of getting this feature into Excel for Mac?

Don't know about getting the feature into XL (you may want to use

http://www.microsoft.com/mswish

to make sure your request is read)

Also, take a look here:

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

 

[Jim Gordon MVP]

Hi Rick,

A farily simply macro can be devised to accomplish this. Check out the
links McGimpsey posted. You can easily copy any worksheet into a new
workbook and send it.

-Jim