How to Set Up Mail Merge in Microsoft Word: A Step-by-Step Guide

Introduction

Mail merge is one of the most practically useful features in Microsoft Word, and also one of the most underused. It allows you to produce hundreds — or thousands — of personalised documents from a single template and a data source, without manually editing each one. Whether you are sending personalised letters to customers, printing address labels for a mailing, creating individual certificates, or producing customised contracts, mail merge handles the repetitive work.

This guide covers the complete process in Microsoft Word, including setting up your data source, inserting merge fields, previewing results, and outputting your merged documents. The steps apply to Word 2019, 2021, and 2024.

When Should You Use Mail Merge?

Mail merge is worth setting up whenever you need to produce five or more personalised versions of the same document. Common use cases include:

• Personalised customer letters or renewal notices
• Address labels for physical mailings
• Employee or student certificates
• Invoices or statements with customer-specific data
• Event invitations with personalised details
• Form letters for legal or administrative correspondence

If you are doing this manually — copying and pasting names and addresses into individual documents — mail merge will save you significant time.

Step 1: Prepare Your Data Source

The data source is where Word pulls the personalised information from. The most common format is an Excel spreadsheet, but you can also use an Outlook contacts list, a Word table, or an Access database.

Setting Up Your Excel Data Source

Open Excel and create a new spreadsheet. The first row should contain column headers — these become the field names you will use in your Word document. Keep headers clear and concise with no spaces (underscores are acceptable). A typical contact list for a letter might look like this:

A few important rules for your data source:

• No blank rows between data rows — Word stops reading at the first blank row
• No merged cells — they confuse the mail merge engine
• Dates should be formatted as text (dd/mm/yyyy stored as text) if you want them to appear in a specific format in the merged document
• Save the file and close it before connecting it to Word

Step 2: Open Word and Start the Mail Merge

Open Microsoft Word and either create a new document or open an existing letter template. Navigate to the Mailings tab in the ribbon.

Click Start Mail Merge and choose the document type that best fits your purpose:

• Letters — full A4 documents, one per recipient
• Email Messages — sends directly via Outlook
• Envelopes — formats the document for printing on envelopes
• Labels — generates a sheet of address labels
• Directory — produces a single document listing all records (useful for catalogues or directories)

For this guide, select Letters.

Step 3: Connect Your Data Source

In the Mailings tab, click Select Recipients → Use an Existing List. Navigate to your Excel file and click Open.

Word will display a dialogue box asking you to select which sheet in the workbook contains your data. If your data is on Sheet1 (or a named sheet), select it and click OK. Ensure the First row of data contains column headers checkbox is ticked — this tells Word that your first row is headers, not data.

At this point, Word has loaded your data but has not inserted anything yet. You can verify the connection is working by clicking Edit Recipient List in the Mailings tab, which shows you all the records Word has read from your file.

Step 4: Filter and Sort Recipients (Optional)

In the Mail Merge Recipients dialogue box, you can:

• Uncheck individual records to exclude specific recipients
• Click a column header to sort by that field
• Use the Filter link to show only records matching specific criteria (e.g., only recipients in a particular city, or above a certain account value)

Filtering is particularly useful for targeted mailings where you only want to contact a subset of your list.

Step 5: Write Your Letter and Insert Merge Fields

Now write your letter in the normal Word document area. When you reach a point where personalised information should appear, click Insert Merge Field in the Mailings tab and select the appropriate field from the dropdown list.

Merge fields appear in your document wrapped in chevrons, like this: «FirstName». A typical letter opening might look like:

Dear «FirstName» «LastName»,

We are writing to you regarding your account at «Company».

You can insert the same field multiple times in a document — for example, inserting «FirstName» in both the salutation and the body text.

Using Address Block and Greeting Line

For standard letters, Word provides two helpful shortcuts:

• Address Block — inserts a formatted block of address fields (name, company, address lines, city, postcode) in one click. Word maps your field names automatically, though you may need to adjust the matching if your column names are non-standard.
• Greeting Line — inserts a formatted salutation such as "Dear Mr. Ahmed," and allows you to configure how names are formatted and what appears when a name is missing.

Step 6: Preview Your Merged Documents

Before generating hundreds of documents, click Preview Results in the Mailings tab. This replaces the merge field placeholders with actual data from the first record in your list. Use the navigation arrows (‹ ›) to step through each recipient and verify the layout looks correct.

Things to check during preview:

• Are there any unwanted blank lines where some records have empty fields (e.g., Address2)?
• Is the date format correct?
• Are names appearing in the right order?
• Does the letter still fit on one page for the longest records?

Handling Blank Lines from Empty Fields

A common problem is that optional fields (like Address2) create blank lines in the address block when they are empty. To fix this: right-click the merge field, select Toggle Field Codes, and you will see the underlying field code. You can suppress blank lines by using conditional IF fields, or simply use the Address Block shortcut which handles this automatically.

Step 7: Complete the Merge

When you are satisfied with the preview, click Finish & Merge in the Mailings tab. You have three options:

• Edit Individual Documents — creates a new Word document with all merged letters on separate pages. This lets you review and manually edit individual letters before printing.
• Print Documents — sends all merged documents directly to your printer. You can choose to print all records, the current record, or a specific range.
• Send Email Messages — sends personalised emails via Outlook using the data from your source. You specify which field contains the email address, the email subject line, and the format (HTML, plain text, or Word attachment).

For most uses, Edit Individual Documents is the safest choice — it lets you do a final check before printing or saving.

Advanced Tips

Conditional Text with IF Fields

You can insert conditional text that changes based on data values using an IF merge field. For example:

{ IF «AccountStatus» = "Premium" "As a Premium member, you receive..." "As a standard member, you have access to..." }

To insert an IF field, use Insert → Quick Parts → Field → IF rather than typing the field code manually.

Formatting Numbers and Dates

Numbers and dates from Excel sometimes appear in unexpected formats when merged. You can control formatting by adding a format switch to the field code. Right-click the field, select Toggle Field Codes, and add a switch:

• { MERGEFIELD Amount \# "£#,##0.00" } — formats as currency
• { MERGEFIELD Date \@ "d MMMM yyyy" } — formats as "21 March 2026"

Mail Merge for Labels

When merging to labels, the process is slightly different. After selecting Labels as the document type, Word asks you to specify the label format (manufacturer and product code, such as Avery L7160). It then creates a grid matching the label sheet. You insert merge fields into the first label cell only, then click Update Labels to replicate the layout across all labels on the sheet.

Getting Started

Mail merge is available in all versions of Microsoft Word 2019, 2021, and 2024. If you need to set it up on a new machine, Office 2024 Professional Plus includes Word alongside Excel, PowerPoint, Outlook, Access, and Publisher — the complete toolkit for professional document work — for a one-time cost of £29.99.