Microsoft KB Archive/826920

= How to use the Send To command to send worksheet selections as an e-mail message in Excel 2003 =

Article ID: 826920

Article Last Modified on 1/11/2006

-

APPLIES TO


 * Microsoft Office Excel 2003
 * Microsoft Excel 2002 Standard Edition

-





IN THIS TASK

 * SUMMARY
 * Send a Worksheet as the Body of a Message
 * Send a Worksheet as an Attachment
 * Send by Using the Internet Fax Service
 * Send to a Routing Recipient
 * Improvements and Requirements
 * REFERENCES



SUMMARY
This article describes how to use the Send To command to send worksheet selections as e-mail.

back to the top

Send a Worksheet as the Body of a Message
To send a portion of a worksheet, or a whole 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 .
 * 1) 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 whole 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 a Worksheet as an Attachment
To send the whole 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

Send by Using the Internet Fax Service
You can connect directly to a fax service provider that will send the fax for you. Before you can send a fax this way, you are prompted to sign up with a fax service provider. For more information about how to use a fax service provider, click Microsoft Excel Help on the Help menu, type fax services in the Search for box in the Assistance pane, and then click Start searching to view the topic. After you sign up with a fax service provider, follow these steps.
 * 1) On the File menu, point to Send To, and then click Recipient using Internet Fax Service.
 * 2) Complete the Fax Recipient, Fax Number, and Subject fields.
 * 3) In the Fax Service pane, select the options that you want, and then complete the cover sheet that is located in the body of the e-mail message.
 * 4) Click Send.

back to the top

Send to a Routing Recipient
You can route a workbook as an attachment to a number of people and track their responses. This workbook can be sent to everyone at the same time, or routed sequentially through the list of recipients.

To route a workbook, follow these steps:
 * 1) On the File menu, point to Send To, and then click Routing Recipient.
 * 2) To select recipients, click Address.
 * 3) Select the recipients, and then click OK.
 * 4) Select the routing options that you want.
 * 5) Click Route.

back to the top

Improvements and Requirements
Microsoft Office Excel 2003 includes new functionality that lets you send a message as a fax by using an Internet fax service.

To turn on the Send To command in Excel 2003, you must have Microsoft Office Outlook 2003 and Microsoft Office Word 2003 installed and configured.

back to the top

