To edit a mail merge field in Word, select it in your document and use the Mailings tab to replace it, or show its field code to adjust details such as date and number formatting. Preview the results before you finish the merge so you can check how the changed field appears with real recipient data.
What You’ll Need
- A Word mail merge main document, such as a letter, email, label, or envelope document.
- The recipient list or data source used by the merge. It may be an Excel workbook, an Outlook contacts list, or another supported source.
- Microsoft Word for Microsoft 365 on Windows. The Mailings commands are similar in Word for Mac, although some keyboard shortcuts and ribbon labels may vary slightly by version.
If you are changing the actual names, addresses, or other recipient information, you may also need the program or file that holds the source list. A merge field is a placeholder in Word; changing the placeholder does not normally change the data in the source.
Step-by-Step
- Open the main merge document. Open the Word file that contains the letter or other merge layout, not just the completed merged output. If you have already used Finish & Merge to create individual documents, those results are separate from the main document and usually do not retain the live connection to the recipient list. Save a copy before making substantial changes, especially if you need to preserve the original layout.
- Check that Word is connected to the right recipient list. Select Mailings > Edit Recipient List to view the current records and confirm that the intended recipients are available. If the document is not connected, use Mailings > Select Recipients to choose an existing list, type a new list, or select Outlook contacts. On Mac, look for the same commands on the Mailings tab; ribbon arrangement can differ between Word versions.
- Locate the field you want to change. Click in the document and look for a placeholder such as «First_Name» or «Address». Select Mailings > Preview Results to switch between field names and the values from a recipient record. Turn preview off again if the values make it harder to identify which placeholder you need to edit. Use the preview record navigation arrows on the Mailings tab to check more than the first recipient.
- Replace an incorrect field with the right one. Click the existing merge field and select it, taking care not to select surrounding punctuation or text. Delete the field, then put the insertion point where it belonged and choose Mailings > Insert Merge Field. Select the correct column name from the list. For example, replace «First_Name» with «Preferred_Name» if that is the field your list actually uses. Type any needed space or punctuation outside the field, such as a space between first and last name.
- Change field formatting when the field itself is correct. If the right data appears but its display is wrong, show the field code instead of replacing the field. On Windows, select the field and press Shift+F9 to toggle its code; Alt+F9 toggles codes for all fields in the document. You may see a code such as
{ MERGEFIELD Date }. Add an appropriate formatting switch inside the code, for example{ MERGEFIELD Date \@ "MMMM d, yyyy" }for a date display such as “November 3, 2026,” or{ MERGEFIELD Amount \# "$#,##0.00" }for a currency-style number. Do not type or delete the special field braces yourself. On Mac, field-code shortcuts may require Option+F9 or the Fn key, depending on the keyboard and Word settings; use the Mailings tab to insert or replace fields if a shortcut does not work. - Update the field and check its result. After changing a code, toggle back to the field result with the same shortcut. Select the field and press F9 to update it if needed. On some Mac keyboards you may need Fn+F9. Then choose Mailings > Preview Results and inspect several records, including one with a long name, a blank value, or an unusual date or amount. A field can look correct for one record and still produce an awkward result for another.
- Change a source column or recipient value in the data file. If the field you need is missing, or the recipient’s information is incorrect, edit the source list rather than merely changing the placeholder. For an Excel source, open the workbook, keep field names in the first row, and change the appropriate heading or record. Save and close the workbook. If Word does not pick up the change, close and reopen the main document, then use Mailings > Select Recipients > Use an Existing List to reconnect to the saved file. Recheck the field list and recipient preview before continuing.
- Finish the merge only after checking the template. Save the main document, preview several records, and then select Mailings > Finish & Merge. Choose the appropriate action, such as Edit Individual Documents to create a separate merged document or Print Documents to print. If you choose to create individual documents, inspect the new output as well: page breaks, long addresses, and blank fields can affect the finished pages even when the template looks fine.
When editing on Mac, the Mailings tab offers the same general workflow, but the location or wording of a command can vary with the Word release. If a function key does not toggle a field, use the ribbon where possible or check the keyboard’s Fn setting.
Common Mistakes
- Editing the completed output instead of the main document. A merged document made with Edit Individual Documents contains recipient-specific results. Change the original main document if you want the correction to apply to future merges.
- Typing a field name as ordinary text. Writing «Last_Name» yourself does not create a live merge field. Insert it using Mailings > Insert Merge Field.
- Changing the field when the source data is the problem. Replacing «City» with «Town» will not correct a wrong city value in the recipient list. Edit the relevant source record instead.
- Typing field braces by hand. The braces shown in a field code are special Word field characters. Ordinary typed braces do not create a working field, and deleting the special braces can break one.
- Checking only the first recipient. Names, dates, and addresses vary. Preview multiple records, particularly if the source has blanks, long entries, or mixed date and number formats.
- Removing useful spaces or punctuation. Spaces and commas are often ordinary text placed around fields. If you delete too much while replacing a field, names can run together or an address can gain extra punctuation.
Tips
- Keep source headings simple and consistent. Use a clear heading in the first row of an Excel list, such as FirstName or PostalCode. Avoid blank or duplicate headings, since they make it harder to identify the correct field in Word.
- Use preview as a check, not as an edit mode. With Preview Results enabled, Word displays recipient values in place of field names. Turn it off when you need to select or identify the underlying merge field.
- Keep merge fields separate from fixed wording. For a greeting, a layout such as “Dear ” followed by the first-name field and a comma makes it clear which part is variable. Consider what should happen when the name field is blank.
- Use formatting switches only when needed. A date or number may be displayed differently depending on the source data and Word settings. A field-code switch can set a consistent display, but preview several records to confirm the chosen format suits the values.
- Save the template separately from the merged output. Give the main document and the finished recipient-specific file distinct names. That makes it easier to find the reusable template next time and reduces the chance of editing the wrong file.
- Keep the source workbook available. Word may rely on the original file path to reconnect to the list. If you move or rename the workbook, you may need to select it again through Mailings > Select Recipients.
Troubleshooting
- The field name appears instead of recipient data: Check that Preview Results is turned on and that the document is connected to the intended list. If preview is on but the field still shows as a code, toggle field codes off with Shift+F9 for the selected field or Alt+F9 for all fields on Windows.
- The field is missing from Insert Merge Field: Confirm the correct recipient list is selected. If you recently added a column, save and close the source file, then reopen or reconnect to it with Mailings > Select Recipients > Use an Existing List. Check that the heading is in the first row and is not blank.
- The date or amount displays incorrectly: First confirm the source cell contains a real date or number rather than text. Then review the field code and its formatting switch. Toggle back to the result and update the field. If the data still looks wrong, test with another recipient and check the source value itself.
- The source changes do not appear in Word: Save and close the source workbook, then close and reopen the Word main document. If necessary, reconnect to the workbook and confirm that the right sheet or table is selected. Avoid editing the source file while Word is using it.
- F9 or another shortcut does nothing: On a laptop or Mac keyboard, function keys may control system features unless you also press Fn. Use the Mailings ribbon for inserting, previewing, and reconnecting fields; shortcuts are mainly useful for toggling and updating field codes.
- The merged output has blank lines or awkward spacing: Check the source for empty values and the template for extra paragraph marks or spaces around fields. Preview records with missing information, adjust the layout, and create a fresh merged output rather than assuming the earlier output updates automatically.
Frequently Asked Questions
Can I rename a mail merge field in Word?
Usually, the field name comes from a column heading in the recipient source. Rename that heading in the source file, save it, and reconnect or reopen the list in Word. Then insert the updated field if it appears in the field menu.
How do I change the format of a date in a mail merge?
Select the date field, show its code, and add a date formatting switch, such as \@ "MMMM d, yyyy", within the field code. Toggle back to the result and preview several recipients. Date values stored as text may need correction in the source list.
Can I edit a recipient’s address in the Word document?
You can change the layout or which address fields the document uses in Word. To correct the recipient’s actual address in future merges, edit the corresponding record in the source list and reconnect or reopen the list if Word does not show the update.
Why do I see «First_Name» instead of a name?
The document may be showing field names because preview is off, or Word may not be connected to the recipient list. Select Mailings > Preview Results and check the list using Edit Recipient List.
Will changing a field update a merge I already printed or sent?
No. Changes to the main document or source list affect a future merge. They do not change pages already printed, emails already sent, or a separate merged document that Word created earlier.
Can I edit fields in Word for Mac?
Yes. Use the Mailings tab to insert fields, preview recipients, and finish the merge. Field-code shortcuts may differ because of function-key settings, so use the ribbon or try the relevant shortcut with Fn if needed.
Related
- Insert a Checkbox in Word: Shortcut and Options
- Insert a Blank Checkbox in Word: Printable or Clickable
- Google Sheets INDEX MATCH Formula: How to Use It Right
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Clear Cache in Microsoft Outlook: Windows, Mac & WebTo clear the cache in Microsoft Outlook, use the method for your version: empty the Auto-Complete list or…
- How to Indent Down in Excel: Cells, Text, and RowsIn Excel, indentation moves cell content horizontally, usually to the right; it does not move text down within…
- Merge Cells in Google Sheets Vertically: How It WorksTo merge cells vertically in Google Sheets, select two or more adjacent cells in the same column, then…
- Google Sheets IMPORTRANGE From the Same Sheet?No: IMPORTRANGE is intended to bring cells into a Google Sheets file from a different spreadsheet file. To…
- Avery Labels in Word: How to Create and Print ThemTo create Avery labels in Microsoft Word, open the Mailings tab, choose Labels, select the Avery product number…
- ISNUMBER in Excel: What It Checks and How to Use ItIn Excel, ISNUMBER checks whether a value is stored as a number and returns either TRUE or FALSE.…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.