Skip to content

Mail Merge in Word: Step-by-Step Letters, Labels and Envelopes

By · · 10 min read

Illustration of a Word document beside a stack of three personalised letters, with the words Mail merge in Word

To do a mail merge in Word, open the Mailings tab, choose Start Mail Merge and pick Letters, Labels or Envelopes. Then use Select Recipients to connect your address list, insert merge fields such as Address Block and Greeting Line, check a few records with Preview Results, and finish with Finish & Merge. Word produces one personalised copy for every row in your list. This guide gives the exact steps for each document type in Word for Microsoft 365 on Windows, with notes for Mac and Word for the web, and shows how to catch the mistakes that ruin a print run.

Mail merge is also a favourite task in office skills tests and interviews, because it shows you can turn a list into finished documents without retyping anything.

Key Takeaways

  • A mail merge has three parts: a main document (the letter, label or envelope), a data source (usually an Excel sheet), and merge fields that pull each value in.
  • Prepare the Excel list first: one header row, all data on the first sheet, and postal codes formatted as text so leading zeros survive.
  • The steps are the same for every document type: Start Mail Merge, Select Recipients, insert fields, Preview Results, Finish & Merge.
  • For labels, set up the first label and then select Update Labels to copy it to every label on the sheet.
  • You need the Word desktop app. Microsoft says you cannot run a mail merge in Word for the web.

What you need before you start

You need three things: the Word desktop app, a clean recipient list, and a few minutes to plan which details each document should show.

Microsoft's overview of mail merge for letters, labels and envelopes lists the data sources Word can use: an Excel spreadsheet, an Outlook contact list, a database Word can connect to, or a Word data file you create during the merge. Excel is the most common choice in offices, so this guide uses it.

The same page says Word for the web keeps mail merge settings made in the desktop app but cannot run a merge or edit those settings. If you only have a browser, open the file in the desktop app (Editing > Open in Desktop App in Word for the web) before you begin.

Step 1: Prepare your recipient list in Excel

Most merge problems start in the spreadsheet, so spend a minute here before you open Word.

A clean list looks like this (all names are fictional):

FirstName LastName Company Address1 City PostalCode
Amara Osei Northfield Supplies 14 Harbour Road Leeds LS1 4AB
Daniel Reyes Brightwater Ltd 220 Mill Street Boston 02134
Priya Nair Kestrel Studio 7 Elm Court Cardiff CF10 2DP

Follow these rules, which come from Microsoft's guide to mail merge using an Excel spreadsheet:

  1. Use one header row with clear column names. Word turns each header into a field name, so "FirstName" becomes the «FirstName» field.
  2. Split details into separate columns. First and last names in their own columns let you write "Dear Amara" or "Dear Ms Osei" later.
  3. Put all the data on the first sheet. Remove blank rows and notes above the header.
  4. Format postal codes, currencies and percentages correctly. Format the postal code column as Text so codes such as 02134 keep their leading zero. Microsoft's envelope merge guide gives the same tip.
  5. Save the file locally and finish editing it before you connect it to Word, then close it.

How to mail merge letters in Word

A letter merge produces one letter per recipient, each starting on a new page. Write the letter first, then turn the personal parts into fields.

1. Start the merge

  1. Open the letter in Word, or start a new blank document and write it.
  2. Go to Mailings > Start Mail Merge > Letters.

2. Connect your list

  1. Select Mailings > Select Recipients > Use an Existing List.
  2. Browse to your Excel file, select it, and choose the sheet that holds your list. Leave First row of data contains column headers ticked.
  3. To leave people out or change the order, select Edit Recipient List. Clear the check box next to anyone who should not get the letter, or use Sort and Filter.

3. Insert the merge fields

  1. Click where the recipient's address should go and select Address Block. Choose a name format, check the preview in the dialog box, and select OK.
  2. Click where the greeting goes, delete any typed greeting, and select Greeting Line. Choose a format such as "Dear Amara," and select OK.
  3. For any other personal detail, click in the text and select Insert Merge Field, then choose the field, for example Company.
  4. Save the document with File > Save.

Merge fields show up in chevrons, like «FirstName». Type spaces and punctuation around them yourself: «FirstName» «LastName» needs a space typed between the two fields, or every letter will say "AmaraOsei".

4. Preview the results

Select Preview Results to replace the fields with real data, then use the Next and Previous arrows to step through recipients. You can also press Alt+Shift+K to preview the merge, a shortcut listed on Microsoft's Word keyboard shortcuts page.

Check at least three records: the first one, one with a long address, and one with any blank cells.

5. Finish the merge

Select Finish & Merge and choose one of:

  • Edit Individual Documents to create a new document with every letter in it. Choose this when you want a final check, or a file to keep.
  • Print Documents to send every letter straight to the printer.
  • Send Email Messages to send each letter as an email from Word.

For most jobs, Edit Individual Documents is the safest choice. You can scroll through the finished letters, fix one-off problems, and then print.

How to mail merge labels in Word

A label merge fills a sheet of sticky labels with one address per label. The extra step is telling Word which label sheet you are using.

  1. Start a new blank document and go to Mailings > Start Mail Merge > Labels.
  2. In Label Options, choose your printer type, then the Label vendors (for example Avery) and the Product number printed on the label packet. Select OK. Word draws a table that matches the sheet. If you cannot see the label edges, click in the table and select View Gridlines on the table Layout tab.
  3. Select Select Recipients > Use an Existing List and open your Excel file.
  4. Click in the first label and select Address Block, then OK. The other labels show «Next Record».
  5. Select Update Labels in the Write & Insert Fields group. Word copies the first label's layout to every label on the sheet.
  6. Select Preview Results and check that the addresses fit. If text spills over, reduce the paragraph spacing or font size in the first label and select Update Labels again.
  7. Select Finish & Merge > Edit Individual Documents, check the sheets, and print with File > Print.

Print one page on plain paper first and hold it against a label sheet. It is cheaper than wasting a pack of labels.

Microsoft's guide to printing labels for your mailing list describes the same process through the Step-by-Step Mail Merge Wizard (under Start Mail Merge), which walks you through each stage in a side pane. Use whichever you prefer; the result is the same.

How to mail merge envelopes in Word

An envelope merge prints the delivery address straight onto each envelope. Envelopes are less forgiving than paper, so test the layout first.

Test one envelope

Microsoft's envelope merge guide recommends printing a test before you merge:

  1. Go to Mailings > Envelopes.
  2. Type a sample delivery address, and your own address in Return address.
  3. Select Options > Envelope Options and choose the size that matches your envelope, or Custom size.
  4. On the Printing Options tab, check the feed method and load the envelope the way the picture shows.
  5. Select Print.

Run the envelope merge

  1. Go to Mailings > Start Mail Merge > Envelopes, check the Envelope Options, and select OK.
  2. Add a return address if it is not already there, then save.
  3. Select Select Recipients and connect your list.
  4. Turn on paragraph marks with Ctrl+Shift+8 so you can see the address area. Click there and select Address Block.
  5. Select Preview Results and step through a few records.
  6. Select Finish & Merge > Print Documents.

Check the merge before you print

A two-minute check prevents reprinting a whole batch. These are the problems that come up most:

Problem Likely cause Fix
Postal codes lose their leading zero Excel stored them as numbers Format the column as Text in Excel, re-enter the codes, and reconnect the list
Letters show «FirstName» or { MERGEFIELD FirstName } Preview is off, or field codes are showing Select Preview Results, or press Alt+F9 to switch field codes off
Two words run together, like "AmaraOsei" No space typed between two fields Type a space between the fields in the main document
An address line is missing Your column names do not match what Address Block expects Select Match Fields and pair each address part with the right column
Blank lines in some addresses Separate fields used for optional lines Use Address Block, which leaves out empty address lines
Dates or amounts look wrong Excel formatting did not carry across Format the cells correctly in Excel before connecting, as Microsoft advises

Also check the Edit Recipient List count. If you expected 40 recipients and Word shows 41, there is probably a blank or header row in the data.

Reusing a merge document

Save the main document after you set it up. When you open it again, Word asks whether to keep the connection to the data source; choose Yes to keep it, as Microsoft's Excel guide explains. You can then update the spreadsheet, reopen the Word file, and merge again without redoing the fields.

Keep the finished letters (from Edit Individual Documents) as a separate file from the main document. The main document is the reusable template; the merged file is a one-off record.

Mac and Word for the web

  • Word for Mac uses the same Mailings tab. Microsoft's Excel merge guide notes that on a Mac you add the address with Insert Merge Field rather than Address Block and Greeting Line, and the email option is called Merge to E-mail.
  • Word for the web cannot run a merge. Open the document in the desktop app to set up, preview or finish a merge.

Practise mail merge on real files

Reading the steps is not the same as doing them. These tasks use fictional recipients and check your merge automatically:

The mail merge module teaches each stage in order, and the lesson on filtering and sorting recipients covers sending to part of a list. If a merge is part of a job application test, the Word skills test guide explains what else to prepare, and how to write a business letter in Word covers the letter you will merge.

Frequently asked questions

Can I do a mail merge without Excel?

Yes. Word can use an Outlook contact list, other databases, or a list you type during the merge with Select Recipients > Type a New List. Excel is common because most address lists already live in a spreadsheet.

How do I merge only some of the rows?

Select Edit Recipient List and clear the check boxes for the people you want to leave out, or use Filter to keep only rows that match a rule, such as everyone whose RSVP column says "Yes".

Why does my merge print one letter per page with blank pages between them?

The main document probably ends with an empty paragraph that spills onto a second page. Turn on paragraph marks with Ctrl+Shift+8 and delete empty paragraphs at the end of the letter.

Can I save each merged letter as a separate file?

Word's built-in Finish & Merge options produce one combined document, a print run or emails. Splitting into separate files needs extra steps or tools, so check whether one combined file or a PDF of it will do the job.

Can I mail merge in Word for the web?

No. Microsoft states that Word for the web keeps merge settings but cannot run a merge. Use the Word desktop app on Windows or Mac.

How this guide was checked

This guide was written by Guccibase and checked on 5 November 2026: each mail merge step against the Microsoft Support guides linked above, using Word for Microsoft 365 menu names. Microsoft updates Word regularly, so if a command on your screen has moved or been renamed, tell us through the help page and the guide will be updated.

Related posts

Written by Guccibase; see how these guides are written. Word Exercises is independent and not affiliated with Microsoft. Menu names follow Microsoft 365 as of 2026.