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

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 item to be sent.
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 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