Microsoft KB Archive/289272

= How To Use the &quot;Send To&quot; Menu Command to Send Worksheets and Workbooks as E-Mail in Excel =

PSS ID Number: 289272

Article Last Modified on 6/29/2004

-

The information in this article applies to:


 * Microsoft Excel 2002

-



This article was previously published under Q289272



IN THIS TASK

 * SUMMARY
 * ** Improvements and Requirements
 * Send Worksheet As Body of Message
 * Send Worksheet As Attachment
 * REFERENCES



SUMMARY
The Send To menu command has been improved in Microsoft Excel 2002. This article discusses how to use this command to send worksheet selections as e-mail.

back to the top

Improvements and Requirements
With Excel 2002, you can now send a selection from a worksheet, or an entire worksheet, as the body of an e-mail message. This behavior is different from that of earlier versions of Excel. In earlier versions, you can send only an entire workbook, and then only as an e-mail attachment.

To enable the new Send To functionality in Excel 2002, you must have Microsoft Outlook 2002 installed and configured.

back to the top

Send Worksheet As Body of Message
To send a portion of a worksheet, or an entire worksheet, as the body of an e-mail message, follow these steps:
 * 1) On the File menu, point to Send To.
 * 2) Click Mail Recipient. Type the e-mail information in the appropriate boxes, and then click Send this  .
 * 3) To cancel this action and return to the Excel workbook, click File, point to Send To, and then click Mail Recipient.

NOTE: When you send a worksheet selection to an e-mail recipient, the Send button text changes to indicate what is being sent, based on what is selected in the worksheet, as in the following example:
 * When a chart is selected, the Send button text changes to Send this Chart.
 * When multiple cells are selected, the Send button text changes to Send this Selection.
 * When a single cell or the entire worksheet is selected, the Send button text changes to Send this Sheet.
 * When a cell inside a Pivot Table is selected, the Send button text changes to Send this Pivot Table report.

back to the top

Send Worksheet As Attachment
To send the entire file as an attachment, as in earlier versions of Excel, follow these steps:
 * 1) On the File menu, point to Send To.
 * 2) Click Mail Recipient (for Review) if you want to send a workbook as an e-mail attachment and track the changes of that shared workbook. Type the e-mail information in the appropriate boxes, and then click Send. To cancel this action and return to Excel, press ESCAPE.

-or-

Click Mail Recipient (as Attachment) if you want to send a worksheet as an e-mail attachment. Type the e-mail information in the appropriate boxes, and then click Send. To cancel this action and return to Excel, press ESCAPE.

back to the top

