How to Perform a Mail Merge in MS Word: A Step-by-Step Guide

If you’ve ever needed to send the same letter to dozens – or even hundreds – of people, each addressed personally, you already understand why mail merge exists. Mail merge is a built-in Microsoft Word feature that lets you combine a single document template with a list of recipient data to produce multiple personalized copies automatically. Instead of typing each person’s name and address individually, you set it up once and let Word do the heavy lifting. This guide walks you through the entire process: building your data source, setting up your main document with merge fields, and completing the merge to print or save your results.

What is mail merge and when should you use it? 🔗

At its core, mail merge works by linking two things together: a main document (your letter, envelope, or label template) and a data source (a list of names, addresses, or other recipient-specific information). When you run the merge, Word reads each row in your data source and generates a unique version of the main document for every recipient – automatically filling in each person’s details where you’ve placed placeholders.

You’d typically use mail merge for scenarios like sending invitation letters to event attendees, mailing annual statements to clients, printing address labels, or distributing personalized certificates. According to GCF Global, mail merge can be used to produce letters, labels, envelopes, name tags, and more – all from one list or database. The time savings compared to manual editing are significant, especially when the recipient list runs into the hundreds.

Step 1: Creating the data source 🔗

The data source is the foundation of any mail merge. It’s the file that holds all the personalized information – names, addresses, email addresses, phone numbers, or any other fields you plan to use in your document.

Preparing your Excel spreadsheet 🔗

The most common and flexible data source is a Microsoft Excel spreadsheet. Microsoft’s official documentation notes that an Excel worksheet works well as a data source provided all the data sits on one sheet and is formatted so Word can read it cleanly. Here’s how to set it up correctly:

• Use the first row for column headers. These headers become the field names in Word. Examples: FirstName, LastName, Address, City, PostalCode, Email. Keep the names short and free of spaces or special characters.
• Enter one record per row. Each row below the header represents one recipient.
• Format postal/ZIP codes as text. If you don’t, Excel may strip leading zeroes (e.g., 01234 becomes 1234). Select the column, right-click, choose Format Cells, and set the category to Text before entering data.
• Avoid blank rows or merged cells. These confuse Word’s import process and can cause records to be skipped.

Creating a list directly within Word 🔗

If you don’t have an existing spreadsheet, you can build a recipient list from scratch inside Word itself. Microsoft Support explains that you go to the Mailings tab, click Select Recipients, and choose Type a New List. A dialog box opens where you can enter recipient details row by row, add new entries with the New Entry button, and even add custom columns using Customize Columns. When finished, Word saves the list as an .mdb file that you can reuse later. This option works well for smaller, one-time lists, but for larger or ongoing projects, an Excel file is easier to manage and update.

Step 2: Setting up the main document 🔗

With your data source ready, the next step is creating the template document in Word – the single master copy that will be personalized for each recipient. This is where you type your standard content and insert merge fields as placeholders wherever recipient-specific data should appear.

Starting the Mail Merge Wizard 🔗

The easiest way to begin, especially if you’re new to the feature, is through Word’s built-in wizard. GCF Global’s guide outlines the six-step wizard process clearly:

1. Open your Word document (either a blank one or an existing letter you want to personalize).
2. Go to the Mailings tab in the ribbon.
3. Click Start Mail Merge → Step-by-Step Mail Merge Wizard.
4. A task pane appears on the right side of the screen, guiding you through each stage.
5. Select your document type – for most business letters, choose Letters.
6. Click Next: Starting document to proceed.

Connecting your data source 🔗

In Step 3 of the wizard, you connect the document to your recipient list. Select Use an existing list, then click Browse. Navigate to your Excel file and click Open. If the workbook has multiple sheets, Word will prompt you to select the correct one – choose the sheet containing your data and click OK.

At this point, the Mail Merge Recipients dialog box opens. Here you can review all the records that will be included in the merge. You can uncheck individual rows to exclude specific recipients, sort alphabetically by any column heading, or apply filters – for example, showing only recipients from a particular city or region. Microsoft’s documentation notes that for advanced sorting and filtering, you can click the arrow next to any column name and use the Filter Records and Sort Records tabs. Once you’re satisfied, click OK to confirm the recipient list.

Inserting merge fields into the document 🔗

Now comes the key part: placing merge fields – the dynamic placeholders – in your document. Move your cursor to where you want a piece of recipient data to appear (for example, the salutation line), then use one of these methods from the Write & Insert Fields group on the Mailings tab:

• Address Block – inserts a combined placeholder for the full name and mailing address. Word lets you choose the format (e.g., whether to include the country, how names are displayed). The placeholder appears as «AddressBlock».
• Greeting Line – inserts a personalized salutation such as “Dear Mr. Smith,” with options to customize the format and choose a fallback greeting for contacts with missing name data.
• Insert Merge Field – gives you a dropdown list of all individual columns from your data source. Use this to insert any specific field anywhere in the document body – for instance, «City» in the middle of a sentence or «Email» in a closing paragraph.

Each inserted field appears surrounded by double angle brackets, such as «FirstName» or «Address». These are not actual data yet – they are instructions telling Word where to pull each piece of information during the final merge. CustomGuide explains that when you place a merge field in the main document, information from that field appears uniquely for each recipient when the merge runs.

Type your full letter around these placeholders just as you would write any standard document. Format the text, adjust spacing, and make sure the fields are logically positioned within sentences. For example:

Dear «FirstName» «LastName»,
We are pleased to inform you that your order will be delivered to «Address», «City».

Step 3: Merging and printing 🔗

With the main document set up and the data source connected, you’re ready to run the merge. But before you commit to printing or saving, it’s important to preview the results first.

Previewing the merged documents 🔗

Click Next: Preview your letters in the wizard (or click Preview Results in the Mailings ribbon). Word immediately replaces all the merge field placeholders with real data from your first record – you’ll see the actual name, address, and other details in place of the angle-bracket fields. Use the left and right arrow buttons to scroll through each recipient’s version of the document.

This step is essential. Check that the names and addresses are appearing correctly, that spacing looks right (no double spaces or missing line breaks), and that any special formatting – such as currency or date formats – is displaying as expected. Mailtrap’s guide points out that date and currency fields sometimes display in unexpected formats due to regional settings, and that this can be corrected by manually adjusting the field codes before finalizing the merge. If you spot any issues during preview, you can go back and edit the main document or the data source before proceeding.

Completing the merge 🔗

Once you’re satisfied with the preview, click Next: Complete the merge. Word presents you with two main options via the Finish & Merge button:

• Edit Individual Documents – Word generates all the merged versions as a single new document, with each recipient’s letter on a separate page. You can scroll through, make last-minute manual edits to specific pages if needed, and then save the file. This is ideal when you want to review the full output or need to make individual tweaks before printing.
• Print Documents – Word sends the merged documents directly to the printer. A dialog box lets you choose whether to print all records, just the current record, or a specific range (e.g., records 1 to 50).

If you’re doing an email merge instead of a printed letter, the option changes to Send Email Messages. Microsoft Support notes that for email merges, Word requires a MAPI-compatible email program such as Outlook to be installed and set as the default mail client. You select the column from your data source that contains email addresses, give the message a subject line, and click OK to send.

Saving your work for future use 🔗

One often-overlooked benefit of mail merge is that your setup is reusable. When you save the main document after completing a merge, Word saves its connection to the data source along with it. The next time you open that document, Word will ask if you want to reconnect to the data source – click Yes, and you can run an updated merge immediately, for example after adding new recipients to your Excel file. This makes mail merge especially useful for recurring communications like monthly billing statements or annual membership renewals.

Common mistakes to avoid 🔗

A few errors trip up first-time users consistently. Keeping these in mind will save you troubleshooting time:

• Missing column headers in Excel. If the first row of your spreadsheet contains data instead of headers, Word will treat that first record’s data as field names, causing incorrect placeholders and garbled output.
• Merge fields showing as field codes. If your placeholders display as { MERGEFIELD FirstName } instead of the actual data or the «FirstName» label, right-click the field and select Toggle Field Codes to switch the display back.
• Extra spaces around merge fields. When placing fields like «FirstName» «LastName», make sure there’s exactly one space between them – no more, no less – otherwise the merged output will look misaligned.
• Data on multiple Excel sheets. Word can only connect to one worksheet at a time, so make sure all your recipient data is on a single sheet before linking the file.

A quick summary of the full process 🔗

To recap, performing a mail merge in MS Word involves three clear stages. First, you prepare your data source – ideally an Excel spreadsheet with properly labeled column headers and one row per recipient. Second, you set up your main document by connecting it to the data source through the Mailings tab and inserting merge fields (placeholders) wherever personalized content should appear. Third, you preview the merged output to catch any errors, then complete the merge by either printing all documents, saving them as a new file, or sending them as emails. The entire workflow, once understood, is repeatable and scalable – whether your list has 10 names or 10,000.

Mail merge is one of those features that genuinely changes how efficiently you can communicate at scale. GeeksforGeeks describes it well: it automates the process of creating multiple documents with unique data, saving hours of manual work. Once you’ve run your first merge successfully, the steps become second nature.

What do you think? Now that you understand how mail merge works, can you think of a real situation in your studies, job, or organization where automating personalized documents this way would save significant time? And if your data source had errors – like missing names or incorrectly formatted postal codes – how would that affect the final merged output, and what would you do to fix it before running the merge?

References

1. https://support.microsoft.com/en-us/office/use-mail-merge-for-bulk-email-letters-labels-and-envelopes-f488ed5b-b849-4c11-9cff-932c49474705
2. https://edu.gcfglobal.org/en/word/mail-merge/1/
3. https://support.microsoft.com/en-us/topic/how-to-use-the-mail-merge-feature-in-word-to-create-and-to-print-form-letters-that-use-the-data-from-an-excel-worksheet-d8709e29-c106-2348-7e38-13eecc338679
4. https://support.microsoft.com/en-us/office/set-up-a-new-mail-merge-list-with-word-1a752328-b1b5-4865-96a2-e0acd561fe6f
5. https://www.customguide.com/course/word/mail-merge-word
6. https://mailtrap.io/blog/mail-merge-word/
7. https://support.microsoft.com/en-us/office/use-mail-merge-in-word-to-send-bulk-email-messages-0f123521-20ce-4aa8-8b62-ac211dedefa4
8. https://www.geeksforgeeks.org/ms-word/how-to-use-mail-merge-in-ms-word/