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
Scripting Languages
Development Tools
Web Development
GUI Toolkits/Desktop
Mail Systems
Eclipse Documentation

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




OpenOffice Writer User Guide
Previous Page Home Next Page

Step 3: Insert address block

This is the most complex step in the wizard.In this step (Figure 286) you will do three things:

  1. Tell the wizard which data source to use. The data source must be a file; in this example it is the spreadsheet created earlier.

  2. Select the address block to use in the document. This means choosing which fields appear (for example, whether the country is included) and how they look.

  3. Make sure that the fields all match correctly. This is very important. For example, the wizard has a field called <Last Name>. If your spreadsheet has a column called “Surnameâ€, you need to tell the wizard that <Last Name> and “Surname†are the same thing. This is described in “Matching the fields†on page 274.


Selecting the data source (address list)

  1. Click Select Address List in section 1. This opens the Select Address List dialog box (Figure 287) for choosing a data source.

  2. If you have not already created the address list, click Create to do so now. If you have an address list, as we have in this example, click Add and select the file.


  1. Select the spreadsheet file and click OK to return to step 3 of the wizard. For this example, the preceding steps are all you need to do. The wizard can also exclude certain records; click Filter to choose them.

Selecting the address block

  1. In step 3 of the wizard (shown in Figure 286), look at section 2. This is where you select the address block to appear on the letter, and define its appearance and the fields it contains. The main page gives two examples. If neither of those is exactly what you want, click More to see more choices, in the Select Address Block dialog box (shown in Figure 288).

  2. The Select Address Block dialog offers six choices for the format of the addresss block (scroll down to see the last two choices). You can also optionally include or exclude the country (for example, only include the country if it is not USA). The six formats provided are relatively common, but they might not exactly match your preference. If this is the case, select the address block that is closest to what you want and click Edit, which opens the New Address Block dialog box.


  1. In the New Address Block dialog (Figure 289), you can add or delete address elements using the arrow buttons on the left. To move elements around, use the arrow buttons on the right. For example, to add an extra space between first and last names in Figure 289, click <Last Name> and then click the right arrow button.


Matching the fields

Finally, it is time to match the wizard’s fields with the spreadsheet fields, so that items like <Last Name> and “Surname†match correctly.

  1. Look at section 3 of step 3 of the wizard (shown in Figure 286 on page 271). The box at the bottom displays one record at a time, using the address block format you selected. Use the right and left arrow buttons below that address box to step through the addresses, checking that they display correctly. Do not assume that all the records display correctly, just because one or two do. Check them all if you can, or at least a good proportion.

  2. If the addresses do not display correctly (and they probably will not right away), click Match Fields. The Match Fields dialog box opens, as shown in Figure 290.


The Match Fields dialog has three columns.

  • Address Elements are the terms the wizard uses for each field, such as <First Name> and <Last Name>.

  • The Matches to Field column allows you to select, for each address element, the field from your data source that matches it.

  • The Preview column shows what will be shown for this field from the selected address block, so you can double-check that the match is correct.

  1. When you have matched all the fields, click OK to return to step 3 of the wizard. Now, when you use the arrow buttons to look at all the addresses, they should all look correct. If not, go back and change anything you’re not happy with, before clicking Next to move to step 4.

OpenOffice Writer User Guide
Previous Page Home Next Page

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