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

Article translations Article translations
Article ID: 826920 - View products that this article applies to.
Expand all | Collapse all

On This Page

SUMMARY

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

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.

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.

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.

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.

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.

REFERENCES

For more information about how to send e-mail, click the following article numbers to view the articles in the Microsoft Knowledge Base:
291217 Types of formatting and features preserved in Excel 2002 workbook sent as body of HTML e-mail message
292488 Excel stops responding when you send worksheet to an unknown mail recipient
296396 "Send to Routing Recipient" does not work

Properties

Article ID: 826920 - Last Review: January 11, 2006 - Revision: 2.4
APPLIES TO
  • Microsoft Office Excel 2003
  • Microsoft Excel 2002 Standard Edition
Keywords: 
kbemail kbhowto KB826920

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com