Writer Guide

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 311 on
page 362). 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
opens, as shown in Figure 315.
Figure 315: Match fields dialog
The Match Fields dialog box 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.
Chapter 11 Using Mail Merge 365