How to Make an Address Book With Open Office

There are a variety of ways to create an address book using OpenOffice. You can open a document or spreadsheet and set-up the book manually. However, if you use the Mail Merge Wizard, you can quickly set up an address book with all of the headings automatically entered. The address book can be sorted in numerous ways, just like a spreadsheet, and the addresses can be exported to other programs.

Difficulty: Moderate

Instructions

1. Open the OpenOffice program. Select "Text Document."

2. Click on "Tools" on the main tool bar. Choose "Mail Merge Wizard."

3. Select "Use the current document" and click "Next." Choose "Letter" and click "Next."

4. Click "Select address list." Highlight "New Database" and click "Create."

5. Type in the contact information for the first contact to be added to your new address book--such as the contact's name, address, phone number and email address. Click "OK" when you are finished.

6. Type in a name for your address book and save it to your desktop or another easy place to find. Click "Save." Click "Cancel" to exit from the Mail Merge Wizard.

7. Double-click on your address book to open it. It will open as a Calc spreadsheet. Check "Tab" to make sure that it opens formatted with rows and columns. Click "OK."

8. Add more contacts to your address book by filling out the information under the headings. Click "Save" when you have completed adding contacts to your address books.

Tips & Warnings

• Format the headings in your address book to make them easier to read. Highlight the heading row and click "B" to boldface the heading font. Insert a row between your column headings and contacts by right-clicking on the first contact row under headings. Choose "Insert new row." This will create a space between the heading row and the contacts.

Resources

• OpenOffice.org Website