E-mailing Spreadsheets

Apache OpenOffice 4.1 Calc Guide

Chapter 6: Printing, Exporting, and Emailing

< Previous Section

Next Section >

• Quick Printing
• Controlling Printing
  • Selecting General Printing Options
  • Printing Multiple Pages on a Single Sheet of Paper
  • Selecting Sheets to Print
• Using Print Ranges
  • Defining a Print Range
    • Adding to the Print Range
    • Removing a Print Range
    • Editing a Print Range
  • Printing Rows or Columns on Every Page
  • Defining a Custom Print Range
• Page Breaks
  • Inserting a Page Break
    • Row Break
    • Column Break
  • Deleting a Page Break
• Printing Options Setup in Page Styles
• Headers and Footers
  • Setting a Header or a Footer
  • Header or Footer Appearance
  • Setting the Contents of the Header or Footer
• Exporting to PDF
  • Quick Export to PDF
  • Controlling PDF Content and Quality
    • General Page of PDF Options Dialog
    • Initial View Page of PDF Options Dialog
    • User Interface Page of PDF Options Dialog
    • Links Page of PDF Options Dialog
    • Security Page of PDF Options Dialog
• Exporting to XHTML
• Saving as Web Pages (HTML)
• E-mailing Spreadsheets
• E-mailing a Spreadsheet to Several Recipients
  • Digital Signing of Documents
• Removing Personal Data

< Previous Page

Next Page >

E-mailing Spreadsheets

OpenOffice provides several quick and easy ways to send spreadsheets as an e-mail attachment in one of three formats: OpenDocument Spreadsheet (OpenOffice’s default format), Microsoft Excel, or PDF.

Documents can only be sent from the OpenOffice menu if a mail profile has been set up and there's an e-mail program available on your computer. If you want to e-mail the spreadsheet using a web service, such as Gmail or the web version of Microsoft Outlook, save the file, then use the web service to attach the document to a message.

To send the current document in OpenDocument format:

1. Choose File > Send > Document as E-mail. OpenOffice opens your default e-mail program with the *.ODS document attached.
2. In your e-mail program, enter the recipient, subject, and any text you want to add, then send the e-mail.

File → Send → E-mail as OpenDocument Spreadsheet has the same effect.

If you choose E-mail as Microsoft Excel, OpenOffice first creates a file in Excel format and then opens your e-mail program with the *.XLS file attached.

Similarly, if you choose E-mail as PDF, OpenOffice first creates a PDF using your default PDF settings (as when using the Export Directly as PDF toolbar button) and then opens your email program with the *.PDF file attached.