Follow Techotopia on Twitter

On-line Guides
All Guides
eBook Store
iOS / Android
Linux for Beginners
Office Productivity
Linux Installation
Linux Security
Linux Utilities
Linux Virtualization
Linux Kernel
System/Network Admin
Programming
Scripting Languages
Development Tools
Web Development
GUI Toolkits/Desktop
Databases
Mail Systems
openSolaris
Eclipse Documentation
Techotopia.com
Virtuatopia.com

How To Guides
Virtualization
General System Admin
Linux Security
Linux Filesystems
Web Servers
Graphics & Desktop
PC Hardware
Windows
Problem Solutions

  




 

 

OpenOffice Writer User Guide
Previous Page Home Next Page

Setting up envelope details from a database

You can use a database as a source of name and address details for printing one or a series of envelopes, either alone or with accompanying letters. Mozilla address books, dBase databases, spreadsheets, databases created by OOo Base, and others can be used as data sources.

After you have set up a data source (see Chapter 10, “Getting Started with Base†in the Getting Started guide), you need to register it with OOo so OOo can access it.

To register a data source, select File > New > Database, select Connect to an existing database, and select the type of data source to connect to. The exact source can then be chosen in the wizard.

For more details on how to set up a database or address book as a data source, see the chapter titled “Getting Started with Base†in the Getting Started guide.

To use the database when printing envelopes:

  1. Click Insert > Envelope from the menu bar.

  2. On the Envelope dialog box (Figure 132), select from the Database list the name of the data source. In the Table list, select the database table or sheet containing the address data that you want to insert. The Database field list will now show a list of the fields in the selected database.

Frame124

  1. Select the field containing the first piece of data (for example, first name) that you want to insert, then click the left arrow button to add the data to the Addressee box.

  2. To put another field on the same line in the Addressee box, select that field and click the left arrow button again. Be sure to include punctuation or spaces between fields in the Addressee box as needed.

  3. To put a field (for example, the address) on a new line, press Enter at the end of the previous line in the Addressee box. When you are finished selecting fields, the Envelope dialog box will look something like Figure 133.

Frame134

  1. Click Insert or New Doc. A formatted envelope is now visible in your document

  2. Click File > Print from the menu bar. The dialog box shown in Figure 134 appears. Click Yes.

    Frame144

  3. The Mail Merge dialog box (Figure 135) appears. Here you can choose to print envelopes addresses to one, several or all address records in the database. For more about using mail merge, see the chapter titled “Using Mail Merge†in this Writer Guide.

  4. Make your selections and then click OK to begin printing.

Frame154

OpenOffice Writer User Guide
Previous Page Home Next Page

 
 
  Published under the terms of the Open Publication License Design by Interspire