How to Add Mail Merge Fields in Word: Step-by-Step

To add mail merge fields in Word, connect a recipient list, place the cursor where personalized information should appear, then choose Mailings > Insert Merge Field and select a column from your list. Save the main document and data source first; preview the results before printing or sending so you can catch missing or misplaced details.

What You’ll Need

A desktop version of Microsoft Word with the Mailings tab. These instructions use Word for Microsoft 365 on Windows; the main ribbon commands are similar in Word for Mac.
A recipient list, such as an Excel workbook, with one person or organization per row and a clear column heading for each value you want to insert. For example, use headings such as FirstName, LastName, Street, and City.
A Word document to use as the template. You can start with a blank document or an existing letter, invitation, label, or other mail merge document.

Mail merge fields are placeholders, not ordinary typed text. Word replaces each one with the matching value from a recipient record when you preview or finish the merge. Your document might show a field such as «FirstName», while the merged copy shows a real name.

Step-by-Step

Prepare and save your recipient list. In Excel, put field names in the first row and the corresponding information underneath. Keep each record on one row, and use a separate column for each type of information. For example, put first names in one column and last names in another. Avoid blank column headings, merged cells in the data area, and extra title rows above the headings. Save the workbook, preferably as an .xlsx file, and close it before connecting it to Word.
Open or create the Word template. Type the parts of the document that will be the same for everyone, such as your organization name, general message, and sign-off. Leave the insertion point where a personalized value should go. For example, type “Dear ” and leave the cursor after the space if you plan to insert a first name. Do not type angle-bracket placeholders yourself; they will not connect to your recipient list.
Choose the type of merge. On the Word ribbon, select Mailings > Start Mail Merge, then choose the appropriate format, such as Letters, E-mail Messages, Envelopes, or Labels. For a standard personalized letter, choose Letters. If you are already working in a merge document, confirm that its merge type suits the job before adding fields.
Connect the recipient list. Select Mailings > Select Recipients > Use an Existing List. Browse to your Excel workbook and open it. If Word asks you to choose a table or worksheet, select the sheet containing your headings and records, and confirm that the option indicating the first row contains column headers is selected. Word will use those headings as the available merge-field names. You can also choose Type a New List to create a small recipient list in Word, or Choose from Outlook Contacts if that is the appropriate source.
Check which recipients are included. Choose Mailings > Edit Recipient List to review the connected records. Use the checkboxes to include or exclude recipients, or sort and filter the list if you need a subset. This is useful when the workbook includes people who should not receive this particular document. Close the recipient list when you are done; the selected recipients remain linked to the merge.
Insert a field at the right position. Click in the document exactly where the personalized value belongs, then select Mailings > Insert Merge Field. Choose the matching heading, such as FirstName or City. Repeat this for each personalized value. A sentence might read “Dear ” followed by the FirstName field, a comma, and then the rest of your message. Word displays merge fields with guillemets, for example «FirstName»; those marks are normal and do not appear as ordinary punctuation in the finished merged copy.
Use a ready-made address or greeting when suitable. Instead of inserting every part separately, choose Mailings > Address Block to add a formatted postal address, or Mailings > Greeting Line to add a salutation. Review the dialog options and preview. If Word does not match a heading to the correct address component, select Match Fields in the relevant dialog and map the available column names to the expected details. Insert individual merge fields when you need more control over wording, spacing, or order.
Preview real records and check the layout. Select Mailings > Preview Results. Word replaces the placeholders with values from a recipient record. Use the previous and next record arrows beside the preview control to inspect several entries, including the first and last records. Check punctuation, spaces, long names, missing values, and line breaks. Turn off Preview Results to return to the field view if you need to edit the template.
Finish the merge only after checking it. Select Mailings > Finish & Merge and choose the next action: Edit Individual Documents creates a new document containing the merged records, Print Documents sends them to a printer, and Send E-Mail Messages prepares personalized email. For email, make sure the recipient list has an email-address column and select that column in the send dialog. A practical safeguard is to choose Edit Individual Documents first, review the generated document, and then print or save it.

On Word for Mac, the Mailings ribbon has the same core commands, though their placement or appearance can vary slightly by release. Connect a source and insert fields through the Mailings tab in the same way. If you cannot see the tab or a command, widen the Word window or use the ribbon search box to find it.

Common Mistakes

Typing a field name instead of inserting it. Text such as «FirstName» typed by hand is only text. Insert the real field using Mailings > Insert Merge Field so Word can match it to the data source.
Using headings that are blank, duplicated, or unclear. Word relies on column headings to identify data. Give every column a distinct heading, such as BillingCity and ShippingCity rather than two columns both called City.
Expecting a field to display a value before previewing. In the template view, Word normally shows the field name. Select Preview Results to inspect the actual recipient data; do not replace the field just because it appears in guillemets.
Adding spaces or punctuation in the wrong place. A merge field supplies its data, not the spaces and punctuation around it. Type a space between adjacent fields where needed, and check how a blank middle name or address line affects the finished result.
Finishing the merge without reviewing records. A template can look correct with one recipient and fail with another whose name is longer or whose data is missing. Preview multiple records before printing or sending.

Tips

Use short, readable column headings without unusual punctuation. Consistent headings make the field list easier to scan and reduce mapping errors.
Build a simple test list with a few varied records: one with a long name, one with an optional field left blank, and one with a different address format. Preview those records before connecting a full list.
Keep a clean, unchanged copy of the recipient workbook. If the source data changes, save it and refresh or reconnect it in Word, then preview again before finishing.
For a reusable template, add a clear note in the document filename or a separate instruction file identifying the expected worksheet and column headings. That makes it easier to use the template with the right source later.
When you need to inspect the underlying Word field code, Windows users can press Alt+F9 to toggle field codes. On Mac, use Option+F9; on some keyboards you may need Fn as well. Toggle back to the regular field display before editing normal text.

Troubleshooting

The field list is empty or a column is missing: Reconnect the correct workbook and worksheet with Mailings > Select Recipients > Use an Existing List. Check that the first row contains the headings, that the desired column is inside the data range, and that its heading is not blank. Save changes in Excel before reconnecting or refreshing the list.

The document shows «FirstName» instead of a person’s name: Make sure Preview Results is switched on and that the document is connected to the intended recipient source. If you see the field code instead of the usual placeholder, toggle field-code display with Alt+F9 on Windows or Option+F9 on Mac. If the field was typed rather than inserted, delete it and add it again from the Insert Merge Field menu.

Every record shows the same person, or the wrong people appear: Check the previous and next record controls while Preview Results is on, then open Edit Recipient List. Confirm the correct workbook and worksheet were selected and that the intended recipient checkboxes are selected. If the source has filters or multiple tables, verify that Word is using the intended data range.

Names or addresses run together or look uneven: Return to the template and inspect the spaces, commas, and paragraph breaks around each field. Preview a record with a blank value as well as one with a long value. For an address, try Address Block and Match Fields, or arrange individual fields and line breaks yourself. If a number such as a ZIP code loses a leading zero, format that data appropriately in the source and verify the preview before completing the merge.

Frequently Asked Questions

Can I add a mail merge field without an Excel list?
Yes. Choose Mailings > Select Recipients > Type a New List to create a small list in Word, or connect another supported recipient source. You still need a recipient record for Word to supply a value when you preview or finish the merge.

Can I type «FirstName» directly into the document?
No. Typing a name between guillemets does not create a working merge field. Place the cursor where the value belongs and choose the matching heading from Mailings > Insert Merge Field.

How do I add a field that is not shown in the menu?
Check that the field is a column heading in the connected source, that it is in the first row of the selected data, and that the correct worksheet or range is connected. Save the source and reconnect it if the heading was added after the list was linked.

Can I format a mail merge field?
Yes. You can apply ordinary character formatting, such as bold or a different font, to the field in the template. Preview the result to confirm the formatting and spacing look right. For data-specific formats, also check how values appear after Word reads them from the source.

How do I add a field to every label?
Choose Mailings > Start Mail Merge > Labels and select the label product. Add fields to the first label, arrange them, then choose Mailings > Update Labels to copy the layout to the other labels. Preview the results before printing on label stock.

Can I use mail merge fields in a personalized email?
Yes. Choose E-mail Messages as the merge type, insert fields in the message, and use Finish & Merge > Send E-Mail Messages. The recipient list needs an email-address column. Preview the message and confirm the selected address field and subject before sending.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.