5.2 Merging Fields

Merging Fields

Once the main document is connected to a data source, the next phase of the mail merge process is inserting merge fields into the template. Merge fields, also known as placeholders, are specialized codes that tell the word processor where to insert dynamic information from the mailing list. When you execute the merge, these field codes are replaced by the actual values from each record. Understanding how to insert, format, and preview these fields is essential for ensuring that the final output looks professional, is punctuated correctly, and maintains proper document layout.

---

Understanding Merge Fields and Placeholders

Merge fields are enclosed in double chevrons (guillemets) when viewed on screen, such as «First_Name» or «City». These symbols are not typed manually using keyboard characters; instead, they are generated by the word processing system when you insert fields from the mail merge interface.

If you type the chevrons manually (e.g., typing <<First_Name>>), the word processor will treat them as standard static text, and they will not pull data from the source file.

Under the hood, these placeholders are represented by underlying field codes. For example, «First_Name» corresponds to the field code { MERGEFIELD First_Name }. In applications like Microsoft Word, you can toggle between the placeholder view and the field code view by pressing Alt + F9 (for all fields) or Shift + F9 (for the currently selected field).

---

Inserting Merge Fields

Word processors provide two primary ways to insert placeholders: using pre-configured composite block fields or inserting individual fields manually.

1. Using Composite Block Fields

• Address Block: Clicking the Address Block button opens a dialog box where you can customize which address elements to include. You can choose whether to print the recipient's country and format the name (e.g., 'Mr. John Smith' or 'John'). A key utility is the Match Fields tool. If your data source column headers do not match the software's internal labels (for example, your column is named 'Post_Code' instead of 'Postal Code'), Match Fields allows you to manually link them so the Address Block displays the data correctly.
• Greeting Line: The Greeting Line dialog box allows you to configure the salutation prefix (e.g., 'Dear', 'To', or none), the name format, and the punctuation (e.g., a comma or colon). It also provides a text input box for a fallback salutation (e.g., 'Dear Customer,') if a specific recipient record has an empty name field.

2. Inserting Individual Fields

For customized layouts, you should insert individual fields directly. On the Mailings tab, click Insert Merge Field to view a list of all column headers from your data source. Clicking a field name inserts it at the current cursor position.

---

The Rule of Spacing and Punctuation

A common trap for beginners is forgetting to add spacing and punctuation between adjacent individual merge fields. The word processor does not automatically insert spaces, commas, or line breaks between merge fields.

If you insert the fields «First_Name» and «Last_Name» side-by-side like this: «First_Name»«Last_Name» The merged output will concatenate the two words directly, resulting in names like JohnSmith.

To resolve this, you must treat merge fields like normal text when editing:

• Insert a space between fields: «First_Name» «Last_Name»
• Insert a comma and a space between city and state fields: «City», «State»
• Use paragraph returns (Enter) to split address lines onto separate rows, just as you would write a standard address block.

---

Editing and Formatting Merge Fields

To change the appearance of the merged data, you must apply the formatting directly to the merge field placeholder in the main document.

• Font Properties: If you want the recipient's name to appear bold, red, and in 14-point Arial font, select the entire «First_Name» placeholder and apply these character formats using the standard home ribbon tools. During execution, every merged record will adopt these style attributes.
• Paragraph Properties: Alignment, line spacing, and bullet styles applied to the line containing a merge field will apply to all records.
• Field Locking: If you do not want a field to update during the merge, you can lock it. In Microsoft Word, selecting the field and pressing Ctrl + F11 locks the field, while Ctrl + Shift + F11 unlocks it.

---

Previewing the Merged Document

Before running the final merge, it is critical to perform a quality check. The Preview Results tool toggles the display of merge fields, showing you the actual data from the mailing list in place of the placeholders.

Step-by-Step Preview Procedure:

1. Go to the Mailings tab.
2. Click the Preview Results button (represented by an icon showing «abc»). The placeholders like «First_Name» will vanish, replaced by the data from the first record (e.g., 'Alice').
3. Use the navigation buttons in the Preview Results group (first record, previous record, next record, last record, or text box input) to scroll through multiple records.

Why Previewing is Critical:

Previewing allows you to catch formatting errors before printing or emailing:

• Text Truncation: Check if long addresses or names cause text wrapping that disrupts the page layout.
• Missing Data: Ensure that if a record is missing data (like a company name), the document does not display empty gaps or ugly spacing.
• Field Mapping Errors: Verify that the correct data is appearing in the correct spot (e.g., that a Zone Improvement Plan (ZIP) code is not showing up in the greeting line).