How to Create a Mail Merge in Microsoft Word: A Step-by-Step Guide

If you regularly send letters, customer communications, invoices, invitations or other personalised documents, creating each one individually can quickly become a time-consuming task.

This is where mail merge in Microsoft Word can help.

Mail merge allows you to create one document and automatically personalise it for multiple recipients using information from a data source, such as an Excel spreadsheet. Names, addresses, company names and other information can all be inserted automatically, helping you prepare larger mailings much more efficiently.

In this guide, we’ll explain how to create a mail merge in Microsoft Word step by step, as well as some important checks to make before you hit print.

What is a mail merge?

A mail merge combines two main elements:

Your main document – the Word document containing the content and design that will remain largely the same for every recipient.

Your data source – a list containing the information that changes for each recipient, such as their first name, surname, company and postal address.

Microsoft Word uses merge fields to tell it where information from your data source should appear.

For example, instead of manually creating:

Dear Sarah,

you can insert a First Name merge field:

Dear «First_Name»,

When you complete the mail merge, Word replaces that field with the appropriate first name for each person in your mailing list.

Microsoft describes mail merge as a way of creating batches of personalised documents using a data source such as a list, spreadsheet or database.

What can you use a Word mail merge for?

Mail merge is particularly useful when you need to produce a large number of documents that follow the same basic format but contain personalised information.

You could use it for customer letters, direct mail campaigns, event invitations, renewal reminders, membership communications, invoices, statements, certificates, envelopes and address labels.

It isn’t limited to names and addresses either. Depending on the information in your database, you could personalise a letter with an account number, customer reference, renewal date, branch location, offer or other relevant information.

What are the benefits of using mail merge?

Save time

The biggest benefit is efficiency.

Instead of copying a letter hundreds of times and manually changing the recipient details, you create the document once and let Word populate the personalised information automatically.

For larger mailing campaigns, this can save a considerable amount of administrative time.

Reduce manual data entry

Manually copying names and addresses between systems increases the opportunity for errors.

With mail merge, information is pulled directly from your chosen data source. That doesn’t mean errors are impossible, your source data still needs to be accurate but it removes much of the repetitive copying and pasting involved in creating individual documents.

Personalise your communications

A personalised letter can feel much more relevant than a generic communication.

Mail merge makes it practical to personalise communications at scale, whether that’s as simple as addressing someone by their first name or using additional fields to tailor the content.

Create consistent documents

Because every letter starts with the same master Word document, your branding, formatting and core message can remain consistent across the entire mailing.

Before you start: prepare your mailing data

This is one of the most important stages of any mail merge.

A beautifully designed letter won’t create the right impression if it arrives addressed to the wrong person, contains a misspelt name or has an incomplete address.

Before connecting your data to Word, spend some time checking and cleaning it.

Structure your spreadsheet correctly

Excel is commonly used as the data source for a Word mail merge.

Ideally, each row should represent one recipient and e   ach column should contain one type of information.

For example:

Clear column headings make it much easier to identify the correct fields when you build your mail merge.

Microsoft recommends preparing and correctly formatting your Excel data before connecting it to Word. In particular, postal codes and similar values may need to be formatted as text so that information such as leading zeros are not lost.

Data checks to make before starting a mail merge

Don’t rush this stage. Good data can make the difference between a professional mailing and one that creates unnecessary waste, returned mail or a poor customer experience.

1. Check names

Look through your data for obvious spelling mistakes and inconsistencies.

Check that first names and surnames are in the correct columns and that titles such as Mr, Mrs, Ms or Dr are appropriate where you’re using them.

Also look at capitalisation. For example:

SARAH JONES

may not look as polished in a personalised letter as:

Sarah Jones

Be particularly careful about automatically changing the case of people’s names, however, as names don’t always follow standard capitalisation rules.

2. Check your greeting format

Think about how the recipient will be addressed.

Will your letter say:

Dear Sarah

or:

Dear Ms Jones

Whichever approach you choose, make sure your database contains all the fields needed to create it consistently.

If some records don’t contain a first name, for example, consider what you want the letter to display instead.

3. Check postal addresses

Review your address data for missing or incomplete information.

Check fields such as the building or house number, street, town or city, county where required and postcode.

Pay particular attention to empty cells. A missing postcode or address line could prevent a mailing from reaching the intended recipient.

4. Check postcode formatting

Make sure postcodes are stored consistently and haven’t been altered by spreadsheet formatting.

Microsoft specifically recommends formatting postal code columns appropriately in Excel to preserve the data when it is used for a mail merge.

5. Look for duplicate records

Check whether the same person or organisation appears more than once.

Duplicates can result in someone receiving the same communication multiple times, which wastes print and postage and can create a poor impression.

6. Remove records that shouldn’t be mailed

Before printing, make sure your mailing list contains only the people who should receive the communication.

Your organisation should also ensure its use of personal data and mailing lists complies with its applicable data protection and marketing obligations.

How to create a mail merge in Microsoft Word

Once your data is ready, you can start building your mail merge.

The exact appearance of Word can vary slightly depending on your version, but the general process for current desktop versions follows the steps below. Microsoft notes that some mail merge functionality may differ or be unavailable in Word for the web or mobile apps.

Step 1: Create your Word document

Open Microsoft Word and create the letter or document you want to send.

Add all the content that will remain the same for every recipient, including your letter text, branding, contact details and calls to action.

Don’t manually enter a recipient’s name or address in the areas you want to personalise, you’ll add these as merge fields shortly.

Step 2: Start the mail merge

From the ribbon at the top of Word:

Mailings > Start Mail Merge > Letters

Choose Letters if you’re creating personalised letters.

Microsoft Word also provides mail merge options for other formats, including envelopes and labels.

Step 3: Select your recipients

Next, tell Word where your recipient information is stored.

Go to:

Mailings > Select Recipients

You can then select your data source.

If you’ve prepared an Excel spreadsheet, choose the option to use an existing list and locate your spreadsheet.

If the workbook contains multiple sheets, make sure you select the sheet containing your mailing data.

Don’t already have a mailing list? Word also allows you to create a new recipient list directly within the program.

Step 4: Insert your mail merge fields

Now you can tell Word where the personalised information should appear.

Click the position in your document where you want the information to be inserted and go to:

Mailings > Insert Merge Field

You’ll see the fields taken from the column headings in your data source.

For example, your address area might look something like:

«First_Name» «Surname»
«Company»
«Address_1»
«Address_2»
«Town_City»
«County»
«Postcode»

You can also use Word’s Address Block feature to create an address from your available data fields.

Step 5: Personalise the greeting

Next, add your personalised greeting.

You could use Word’s Greeting Line feature or build your own greeting using individual fields.

For example:

Dear «First_Name»,

Using individual fields can give you greater control over exactly how the greeting appears.

Word also supports mail merge rules for more advanced personalisation. These can be used to change content depending on information in your data source.

Step 6: Preview your mail merge

This is a step we’d strongly recommend never skipping.

Select:

Mailings > Preview Results

Word will replace your merge fields with actual information from your recipient list.

Use the previous and next controls to move through different records rather than checking only the first recipient. Microsoft recommends previewing the results before completing the merge.

What should you check when previewing a mail merge?

Look at the document as if you were the person receiving it.

Check that:

• Names appear correctly and are formatted consistently.
• The greeting makes sense for each recipient.
• Address lines appear in the correct order.
• There aren’t awkward blank spaces caused by missing data.
• Postcodes are displayed correctly.
• Long company or recipient names don’t disrupt the layout.
• Personalised information hasn’t pushed text onto an unexpected additional page.
• Page breaks haven’t appeared in the wrong place.
• Fonts, spacing and alignment remain consistent.
• Any dates, numbers or other personalised fields display correctly.

It’s worth deliberately checking some unusual records too. Find recipients with particularly long names, long addresses, missing Address Line 2 fields or other variations. These are often where formatting issues become apparent.

Step 7: Create a test before printing the full mailing

For a large mailing, don’t go straight from previewing the first record to printing hundreds or thousands of copies.

Create a small test first.

Print a selection of records and check the physical output. If the letter is going into a window envelope, fold the test document and make sure the recipient’s address appears correctly within the window.

Check the print quality, positioning, margins, page count and any variable information.

Catching an issue at this stage could save a significant amount of wasted paper, ink or toner, envelopes and time.

Step 8: Finish your mail merge

Once you’re happy with everything, go to:

Mailings > Finish & Merge

Word gives you options including Edit Individual Documents and Print Documents.

For an important or larger mailing, Edit Individual Documents can be particularly useful because Word creates a new document containing the merged letters. This gives you another opportunity to inspect the finished output before sending it to print.

Step 9: Save your mail merge template

If this is a mailing you’re likely to repeat, save your original Word mail merge document.

Word can retain its connection to the mailing list, making the document easier to reuse for future communications.

Just remember: always check the data again before the next mailing.

A spreadsheet that was accurate six months ago may no longer be accurate today.

Common mail merge mistakes to avoid

Most mail merge problems aren’t caused by the merge itself, they’re caused by the data or by not checking the finished document thoroughly enough.

Common problems include duplicate recipients, missing names, incorrect titles, inconsistent capitalisation, incomplete addresses, incorrect postcodes, blank address lines, old customer information and unexpected formatting.

Another common mistake is checking only one or two records before printing.

A mail merge containing 1,000 recipients might look perfect for the first 20 records but have a particularly long company name or unusual address further down the list that affects the document layout.

A few extra minutes spent checking your data and merged documents can prevent a much bigger problem later.

A simple mail merge checklist

Before sending your mailing to print, ask yourself:

• Has the recipient data been checked and cleaned?
• Have duplicates been identified?
• Are names formatted correctly?
• Are postal addresses complete?

☐ Are postcodes correctly formatted?

☐ Have unnecessary records been removed?

☐ Do the merge fields correspond with the correct spreadsheet columns?

☐ Have several different records been previewed?

☐ Have long names and addresses been checked?

☐ Have blank fields been tested?

☐ Has a physical test copy been printed?

☐ Does the address align correctly if you’re using a window envelope?

☐ Is the final page count what you expected?

☐ Have you checked the merged document before committing to the full print run?

If the answer to all of these is yes, you’re in a much stronger position to start printing.

From mail merge to finished mailing

Mail merge is a simple but powerful way to make producing personalised letters quicker and more efficient. Once you’ve created a reliable template and well-structured data source, the same process can be used for everything from small customer mailings to much larger direct mail campaigns.

And creating the merged document is only one part of getting a mailing out of the door.

My Mailing Room can help businesses manage the wider mailing process, including data, printing, fulfilment and postage.

Whether you’re planning a one-off customer communication or a larger direct mail campaign, our team can help you turn your data and artwork into a professionally produced mailing that’s ready to reach your audience.

Talk to the My Mailing Room team about your next mailing campaign.