Mail Merge in Microsoft Word: A Step-by-Step Guide for Printing Letters

Imagine you've been given a task: send personalized invoices or letters to 200 clients. If you opened each letter, typed the name and address by hand, then printed it, you'd be there all day. Probably all week.

That's where mail merge comes in. It automatically creates personalized copies of a document — one for each person in your contact list. Name, address, account number, whatever you need — it gets filled in automatically.

This guide walks you through the entire process, from setting up your contact list to printing the final letters.

What You'll Need

• Microsoft Word (2019, Microsoft 365, or Office 2021 — any recent version works)
• A contact list — I'll show you how to create one
• A letter template — I'll show you the basics

Step 1: Prepare Your Contact List

Your contact list is the spreadsheet that Word will pull names and addresses from. It needs headers (column names) for each piece of information you want in your letter.

Open a new Excel workbook (or any spreadsheet app) and create columns like this:

Important rules: - Headers must be one row, no blank rows above them - Keep header names simple — no spaces or special characters if possible (use underscores) - Save as CSV — Go to File → Save As → Choose "CSV (Comma delimited) (.csv)" - Close the file* — Word needs exclusive access to read the CSV. If it's open in Excel, Word won't be able to use it.

Where to get your contact data: - Export from Outlook, Gmail, or any CRM - Copy-paste from an existing customer database - Type it manually for small lists

Step 2: Create Your Letter Template

Open Microsoft Word and write your letter. Leave placeholders (I use chevrons like «Name») where you want the merged data to appear.

Here's a simple example:

[Your Company Logo]

Date: [Insert Date]

«First_Name» «Last_Name»
«Address_1»
«City»
«Postcode»

Dear «First_Name»,

Thank you for choosing [Company Name] for your home insurance needs.
Your policy is due for renewal on [Date].

Please find your personalized invoice attached.

Best regards,

[Your Name]
[Your Position]

Don't worry about formatting the merge fields yet — we'll do that in the next steps.

Step 3: Connect Word to Your Contact List

Now we tell Word where the data is.

1. Click the Mailings tab in the ribbon at the top of Word
2. Click Select Recipients → Use an Existing List
3. Browse to your .csv file and select it
4. Click Open

If your CSV has multiple sheets, Word will show you which one to use. For a simple CSV, there's only one sheet — just click OK.

Step 4: Insert Merge Fields

Now replace the placeholders in your letter with actual merge fields:

1. In your letter, highlight the text you want to replace (e.g., «First_Name»)
2. In the Mailings tab, click Insert Merge Field
3. Choose the matching field from the drop-down list (e.g., First_Name)
4. Repeat for every field

When a merge field is inserted, it will appear with double arrows around it, like «First_Name» or «Address_1». This means Word knows where to pull the data from.

Go through your entire letter and replace each placeholder with the correct merge field. You might need to adjust spacing — remove any extra spaces between fields so the final output looks clean.

Step 5: Preview Your Letters

Before you print, check that everything looks right:

1. In the Mailings tab, click Preview Results
2. Word will show you the first letter with real data filled in
3. Use the Next Record and Previous Record buttons (the left/right arrows) to scroll through all your contacts

Check for: - Names that look odd or truncated - Address lines that are too long - Missing fields (shows as blank where data should be) - Formatting issues (line breaks, spacing)

If something looks wrong, click Preview Results again to return to editing mode, adjust the field positions, then preview again. Repeat until every letter looks right.

Step 6: Complete the Merge

Once you're happy with the preview, you have two options:

Option A: Print Directly

1. Click Finish & Merge → Print Documents
2. Choose All (or select specific records)
3. Click OK and your printer will churn out every letter

This is the fastest option if everything is perfect and you want paper copies.

Option B: Create a New Document

1. Click Finish & Merge → Edit Individual Documents
2. Choose All
3. Word creates a new document with every letter on a separate page

This option is useful when: - You want to review every letter before printing - You need to make manual tweaks to specific letters - You want to save the merged letters as a PDF - You want to email the letters instead of printing

Bonus: Mail Merge for Email

You can also use mail merge to send personalized emails directly from Outlook:

1. Open Word, go to Mailings tab
2. Click Select Recipients → your contact list
3. Insert merge fields as usual
4. Click Finish & Merge → Send Email Messages
5. Set the To field to your email column header
6. Type a subject line (you can use merge fields here too)
7. Choose All or specific records and click OK

This works with Microsoft Outlook only (not Gmail, Yahoo, etc.). For Gmail, you'll need third-party add-ons or Google Workspace's mail merge feature.

Common Problems (And Fixes)

The CSV file is grayed out / can't be selected The file is open in another program (usually Excel). Close Excel and try again.

Fields show «field_name» instead of actual data You're in editing mode, not preview mode. Click Preview Results to see real data.

All letters have the same address The merge fields aren't connected properly. Check that you inserted merge fields (from the Mailings tab), not typed text.

Date format looks wrong Format dates in your Excel spreadsheet before saving as CSV, or use the \@ "dd MMMM yyyy" date format switch in Word (right-click the date field → Toggle Field Codes → add the format switch).

Numbers have too many decimal places Format number columns in Excel to 2 decimal places before exporting to CSV.

Final Tips

• Save your merged document — Once you create the individual document (Option B), save it. You might need it again.
• Keep your CSV simple — The fewer columns, the less chance of errors. Only include fields you'll actually use in the letter.
• Test with 2-3 records first — Before merging 500 letters, test the merge with a small subset. Catch errors early.

Mail merge is one of those Office features that looks complicated the first time but becomes second nature once you've done it twice. It saves hours on repetitive document creation. Once you've got the hang of it, you'll wonder how you ever lived without it.

For more ICT tutorials, check out my other guides on Microsoft Office and productivity tools.