To mail merge letters in Word, put each person’s name and address in an Excel table, then in Word select Mailings > Select Recipients > Use an Existing List. Add a Greeting Line and an Address Block, preview the letters, then select Finish & Merge > Edit Individual Documents to put every letter in one document ready to print. To send emails instead, see how to use mail merge in Word for emails.
In this guide, you’ll follow the same steps as the video, from the Excel address list to the finished letters. The steps are for Word in Microsoft 365, Word 2021, Word 2019 and Word 2016 for Windows.
What Mail Merge Letters Does
Mail merge takes one letter and a list of people, and produces a separate copy for each person with their own name and address filled in. It saves typing the same letter again and again, and it suits invitations, newsletters, reminders and reports home.
Use Your Country’s Format
The video uses UK addresses with a postcode. Use the column names your country needs, such as ZIP code.
One Header Row
The column headings must be in row 1 of the sheet, with no blank rows above them.
Watch the Video Tutorial
If you prefer to see this in action, the full video walkthrough is below, showing each method step by step.
Step 1: Build the Address List in Excel
- Open a blank workbook. In row 1, type First Name, Last Name, Address Line 1, City and Postcode.

- Under the headings, type each person’s details, with no gaps between rows.

- Select all the data, including the headings, then Insert > Table. Keep My table has headers ticked and select OK.

- Save the workbook with a clear name, then close Excel.
Step 2: Connect the List in Word
- Open a new Word document and select Mailings > Select Recipients > Use an Existing List.

- Find your saved workbook, select it and select Open.
- Choose the sheet, keep First row of data contains column headers ticked and select OK.

- Select Edit Recipient List to check every name and address came through, then select OK.

👉 If you change the Excel list later, open Edit Recipient List and select Refresh.
Step 3: Write the Letter
- Type the body of the letter. Leave out the greeting and the address: mail merge adds them.

Step 4: Add the Greeting Line
- Click where the greeting goes, then select Mailings > Greeting Line.

- Keep Dear, choose a name format and a comma, then use the arrows to check each recipient. Select OK.

- Select Preview Results to see the real names, and use the arrows to move between letters.

👉 Before preview, the letter shows «GreetingLine». That placeholder is working correctly.
Step 5: Add the Address Block
- Click above the greeting and turn off Preview Results.
- Select Address Block. Keep the name format, tick or untick Insert postal address and check the preview on the right.

- If a line is wrong, select Match Fields and pick the right Excel column, such as City. Select OK twice.

👉 With Preview Results on, each letter now shows its own name and address.

Step 6: Lay Out the Address Your Way (Optional)
Want the postcode on its own line, or a different order? Build the address from separate fields instead of the Address Block.
- Delete the «AddressBlock» placeholder.
- Select Insert Merge Field > First_Name, type a space, then insert Last_Name.

- Press Enter and insert Address_Line_1, City and Postcode, each on its own line.

👉 To close the gaps between the address lines, select them and choose Home > Line and Paragraph Spacing > Remove Space After Paragraph.
Step 7: Merge and Print the Letters
- Select Finish & Merge > Edit Individual Documents.

- Choose All and select OK.
👉 Word puts every letter in a new document, one per page. Check them, then press Ctrl + P to print.

Quick Tips
Check Before Printing
Edit Individual Documents lets you fix any letter by hand before you print the whole batch.
Envelopes and Labels
Use the same Excel list for envelopes or address labels: see how to make labels in Word.
Save the Main Letter
Save the Word letter. Next time, it reconnects to the same Excel list.
Matching Envelopes
Print envelopes to go with your letters using the free envelope templates for Word.
FAQs
How do I mail merge letters in Word?
Make an address list in Excel, connect it with Mailings > Select Recipients > Use an Existing List, add a Greeting Line and an Address Block, then select Finish & Merge > Edit Individual Documents.
Do I need Excel to mail merge letters?
Excel is the easiest source, but Word can also use a list typed in Word with Type a New List, or Outlook contacts.
Why does my letter show «GreetingLine»?
That is the placeholder. Select Preview Results on the Mailings tab to see the real names.
How do I change the address layout?
Delete the Address Block and insert the separate merge fields, such as First_Name and City, in the order you want.
How do I print all the merged letters?
Select Finish & Merge > Edit Individual Documents > All, then press Ctrl + P in the new document.
Can I mail merge letters to only some people?
Yes. Select Edit Recipient List and untick anyone you want to leave out.
Conclusion
Mail merge letters in Word in seven steps: an Excel address list, a greeting line, an address block and one merge give you a personalised letter for everyone on the list.
Sending the same message by email instead? Follow how to use mail merge in Word for emails.
Related Tutorials
- How to Use Mail Merge in Word: Send Personalised Emails
- How to Make Labels in Word: 6 Easy Steps (Quick Guide)
- 28 Essential Mail Merge Shortcuts in Word (Free PDF)
Word Tutorials
Recently Added on Word Made Easy
Browse the complete collection for help with formatting, layout, pages, tables, images, and document setup.
For Microsoft support documentation, visit the official Microsoft guidance.

Leave a Reply