Outlook and Excel

Excel's worksheet files can be used in much the same way as Access data files. Choose File, Send To from Excel's menu and use the new Office Envelope feature to email a spreadsheet to someone. In addition, you can use Excel and Outlook together to create workbook- related tasks and to share data. The following steps show you how to create an Outlook task in Excel:

  1. Open Microsoft Excel.

  2. Right-click any toolbar.

  3. Select the Reviewing toolbar from the menu.

  4. On the Reviewing toolbar, click the Create Microsoft Outlook Task button.

  5. As with Word, a Task tool appears, and you can fill in the necessary information. Click Save and Close to complete the task.

If you anticipate creating a lot of workbook-related tasks, use the tip suggested in the previous section, and move the Task button to Excel's Standard or Formatting toolbar.

You can also use Office's new Envelope feature to email an Excel spreadsheet in HTML format, as the following steps show.

  1. In Excel, open the worksheet you want to send and click the E-mail button on the Standard toolbar. This adds normal email headers to the top of the Excel window.

  2. Use the To:, Cc:, and other header fields as you would for email sent using other techniques.

  3. Click Send this Sheet. This sends the current worksheet in HTML format.


When you send a complex HTML document that contains graphics such as charts , you should preview what you're sending to make sure it will appear as you want. Before you send it to somebody else, send it to yourself first. After verifying that it looks correct, repeat the procedure to send the file.

Sams Teach Yourself Office Productivity All in One
Sams Teach Yourself Office Productivity All in One (Sams Teach Yourself All in One)
ISBN: 0672325349
EAN: 2147483647
Year: 2003
Pages: 474
Authors: Greg Perry

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net