How to Make an Address List in OpenOffice
OpenOffice is a free, open-source productivity suite. It features similar programs to Microsoft Office as well as the ability to import Office files. OpenOffice is compatible with Windows, Mac and Linux operating systems. There are a couple of ways to make an address list in OpenOffice. Import address data from other databases, create your own database or use the Mail Merge Wizard to create a CSV file, which you can then modify.
Other People Are Reading
Instructions
-
Import Address Data
-
1
Open OpenOffice Writer.
-
2
Click on "File" in the menu bar. Highlight "Wizards," and click on "Address Data Source."
-
-
3
Select your external address book. Click "Next."
-
4
Select the "Table" that contains the addresses you wish to import. Click "Next."
-
5
Specify the directory where you wish to store your address list, and name the address list. Check "Make this address book available to all modules in OpenOffice.org." Click "Finish."
Family Address Extension
-
6
Download and extract the Family Address Book Extension for OpenOffice (see Resources for link).
-
7
Open Family AddressBook.
-
8
Import address data by copying fields in an OpenOffice Calc spreadsheet. Click on "Tables" in the left "Database" column of Family Address Book. Right-click on "InformationTable," and left-click on "Paste."
-
9
Add new addresses to the address list by clicking on "Forms," then selecting "Add New Family." Fill out the fields you want to include, and save as you add new entries.
Use Mail Merge
-
10
Click on "Tools," then "Mail Merge Wizard."
-
11
Choose your document preference, then click on "Next."
-
12
Select "Letter" or "Email" as your document type, and click on "Next."
-
13
Click "Select Address List." Click "Create."
-
14
Fill out one entry, skipping any fields you do not wish to use. Click "OK" when done.
-
15
Type in a "File Name." The file type should be set as CSV. Click "Save."
-
16
Click "Cancel" twice.
-
17
Click on "Open" in the menu bar. Navigate to the CSV file you saved earlier and double-click it.
-
18
Click on "Tab" and "Comma" in the "Separated By" section. Click "OK."
-
19
Add new entries. Save prior to exiting the address list.
-
1
Tips & Warnings
You must enter your connection settings and select tables to import if you choose to import from a server-based database, such as LDAP. Type the hostname and username. Select whether a password is required. Click "Test Connection" to make sure OpenOffice can communicate with the database.
