E-mailing spreadsheets

OpenOffice.org 3 Calc Guide

Chapter 6 Printing, Exporting, and E-mailing

< Previous Section

Next Section >

• Printing
• Using print ranges
• Page breaks, headers and footers
• Exporting to PDF
• E-mailing spreadsheets
• Digital signing
• Removing personal data

< Previous Page

Next Page >

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

To send the current document in OpenDocument format:

1. Choose File > Send > Document as E-mail. OpenOffice.org opens your default e-mail program with the spreadsheet (*.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, OOo 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, OOo 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.

E-mailing a spreadsheet to several recipients

To e-mail a document to several recipients, you can use the features in your e-mail program or you can use OOo Writer’s mail merge facilities to extract email addresses from an address book.

For details, see Getting Started: Printing, Exporting, and E-mailing.