How to Mail Merge in Word UK: Step-by-Step Instructions

To mail merge in Word, prepare a recipient list in Excel, connect it through Word’s Mailings tab, insert merge fields, preview the results, then choose Finish & Merge to create or print personalised documents. You will need Word, a tidy data list and a few minutes to check the output before sending it.

A mail merge combines one template with a list of people or organisations. Word makes a separate letter, label, envelope or email for each record, replacing fields such as name and address with the matching details. The steps below use Microsoft 365 for Windows and UK examples; ribbon wording can vary slightly in other Word versions.

What You’ll Need

Microsoft Word for Microsoft 365 on Windows. A recent desktop version of Word for Mac can also perform mail merges, though some controls and dialog boxes may be arranged differently.
A recipient list, preferably in an Excel workbook, with one row per recipient and a clear heading at the top of each column, such as FirstName, Surname, Address1, Town and Postcode.
A Word document to use as your template. You can start from a blank document or make a copy of an existing letter.
For an email merge, an email address column and a supported desktop email setup. Word’s Send Email Messages command commonly relies on a configured Outlook account.

Keep the workbook saved and close it before connecting it to Word. Check that there are no completely blank rows in the middle of the list, that each heading is unique, and that the first row contains headings rather than a recipient’s details. Store postcodes as text where possible so Excel does not alter their appearance.

Step-by-Step

Prepare the Excel recipient list. Put each person or organisation on a separate row, with one type of information in each column. For example, keep first name and surname in separate columns if you may want to greet recipients by first name. Use one column for each part of a UK address, and use headings such as Address1, Address2, Town, County and Postcode. Remove unnecessary title rows, merged cells and blank rows. Save the workbook in a location you can find, then close Excel.
Start the merge in Word. Open the document that will become your template. Select Mailings > Start Mail Merge and choose the type you need, such as Letters. For a standard letter, Word leaves the page layout available for your text. Choose Directory only when you want one continuous document containing a list of records, rather than a separate page or document for each person.
Connect your Excel file. Select Mailings > Select Recipients > Use an Existing List, browse to the workbook and select it. If Word asks which table or worksheet to use, choose the sheet containing the list and confirm that the first row contains column headings. In Word for Mac, use the Mailings tab’s recipient-list or select-recipients controls; their exact labels and prompts can differ by release. If the workbook does not appear, check that it is saved as an Excel workbook and close it before trying again.
Check the recipient records. Select Mailings > Edit Recipient List to review the names and decide which records to include. You can untick people who should not receive this mailing, sort the list or filter it where the available options allow. Check that the number of selected recipients is plausible. A wrong worksheet or an accidentally selected header row can lead to missing or unexpected records later.
Write the common text. Type the parts of the letter that are the same for everyone, such as the date, subject line, main message and sign-off. Leave the cursor where personal details should appear. Add punctuation and spaces around fields deliberately: a greeting might read “Dear ” followed by a first-name field and a comma. The greeting should still read naturally if some records have a title or a different type of name.
Insert personalisation fields. Place the cursor at the insertion point, then select Mailings > Insert Merge Field and choose the matching column heading. Build the address block or greeting from fields and ordinary text. For example, insert FirstName after “Dear ”, and put Address1, Town and Postcode on separate lines in the address area. Use Word’s Address Block or Greeting Line tools if their suggested layouts suit your data, but check the result rather than assuming they will match your preferred UK format.
Format the document around the fields. Set the font, paragraph spacing and page layout as you would for an ordinary Word document. To display a postcode on the same line as a town, place the fields and punctuation accordingly; to use a conventional postal layout, put address lines on separate paragraphs. Avoid adding a literal comma or extra space that will look odd when a field is blank. If a field is missing from the insert menu, check its heading in Excel and reconnect the correct worksheet.
Preview actual records. Select Mailings > Preview Results. Use the previous and next record arrows to inspect several entries, including the first, last and any records with long names or optional address lines. The preview shows the real data in place of field names. Look for doubled spaces, missing punctuation, text wrapping, blank lines and details appearing in the wrong place. Turn Preview Results off to return to the field-code view if you need to edit the template.
Complete the merge. Select Mailings > Finish & Merge. Choose Edit Individual Documents to make a new Word document containing the merged records, Print Documents to send them to a printer, or Send Email Messages for an email merge. For letters, editing individual documents first is a useful final check: review the pages, correct any one-off issue, then print the merged copy. If printing directly, confirm the recipient range and printer settings in the next dialog.
Save and verify the final output. Save the merged document with a clear name, separate from the original template, if you need a record or want to review it later. Check page breaks and addresses in the finished document before printing or sending. The template remains linked to the recipient list, so keep both files together if you expect to reopen the merge and update the data later.

Formatting UK dates: Date values may display in a format you did not expect, particularly if Word reads a value differently from Excel’s display. You can apply a Word date switch to a merge field. First show the field codes by right-clicking the date field and choosing Toggle Field Codes. A date field can use this form: { MERGEFIELD Date \@ "d MMMM yyyy" }. The braces must be Word field braces, not typed curly-brace characters: insert them with Ctrl+F9 on Windows, then type the field contents inside. Right-click and select Update Field, or preview the merge again, to check the result, for example 3 November 2026. On Mac, use the field-code options available from the context menu; keyboard combinations can depend on the keyboard and Word version.

Common Mistakes

Using the wrong data range. If the workbook contains several sheets or a title above the headers, Word may connect to the wrong table or treat the wrong row as headings. Keep the recipient list in a simple, clearly labelled worksheet and inspect the selected sheet during connection.
Typing field names instead of inserting fields. Typing «FirstName» or the word FirstName into the template does not link it to Excel. Insert each item using Mailings > Insert Merge Field, then check it in Preview Results.
Leaving inconsistent or incomplete records. Missing postcodes, mixed address formats and blank name cells can make a letter look careless. Filter or review the source list before merging, and decide how the template should handle optional information.
Trusting the first preview. One short name may look fine while a longer name pushes text onto another line. Inspect different records and the merged document itself, especially when printing a large batch.
Printing before checking the range. Finish & Merge can include all selected recipients, not just the record currently visible in preview. Confirm the intended recipient range before committing to a print run.

Tips

Use short, descriptive, unique headings in Excel. Avoid punctuation-heavy names and headings that are repeated in more than one column.
Keep a clean master list and make a separate copy when you need to remove or change recipients for one mailing. This protects the source data.
Use Preview Results alongside the recipient navigation arrows to check the full range efficiently. Check records with blank optional fields as well as typical records.
For a label merge, choose Mailings > Start Mail Merge > Labels, select the label manufacturer and product number, and use Update Labels after designing the first label. Confirm the label packaging matches Word’s selected product number.
For an email merge, make the message in the main document, then choose Finish & Merge > Send Email Messages. Select the email-address column, add a subject and choose the message format. Send a test to yourself first; a Word email merge generally sends an individual message per selected record, not one message with all recipients visible.
Keep your template and workbook in a stable folder. Moving or renaming the workbook can break the connection, in which case select the correct recipient list again.

Troubleshooting

Word cannot find the workbook or asks for a data source: Confirm the file is saved, close it in Excel and browse to it again using Mailings > Select Recipients > Use an Existing List. If you moved the workbook after connecting it, reconnect to its new location.

The merge fields are missing or show the wrong headings: Go to Edit Recipient List and check the selected sheet. Revisit the workbook to ensure the headings are in the first row of the data range, then select the list again. If the column was added after the connection, reconnect Word so it can refresh the available fields.

Every preview shows the same person: Check whether Preview Results is on and use the next-record arrow. If the record does not change, confirm that the recipient list contains multiple selected rows and that you have not filtered the list down to one person.

A date or number looks different from Excel: Word may use the stored value rather than the display format you applied in Excel. For dates, format the Word merge field with a date switch as described above. For values such as postcodes or account references, store them as text in the source list if leading zeroes or exact characters must be preserved, then reconnect and preview again.

Blank lines or awkward gaps appear: Check for empty cells in the source data and remove extra paragraph marks or spaces around the relevant fields. Use an address-block option that suppresses empty lines where suitable, or arrange the individual fields so optional lines do not leave unwanted gaps. Preview records where those fields are blank.

The output is too long, or labels do not line up: In the merged document, inspect records with the longest content and check font size, paragraph spacing and page breaks. For labels, verify the manufacturer and product code against the label packet, check the printer’s paper-size setting, and use Word’s label layout rather than manually spacing text with repeated spaces.

Frequently Asked Questions

Can I use Excel for the recipient list?
Yes. Excel is a convenient source for a Word merge. Use one heading row, one recipient per row and consistent columns, then select the workbook through Mailings > Select Recipients > Use an Existing List.

Can I mail merge in Word without Excel?
Yes. Word can use an existing recipient list or you can create a new list through Mailings > Select Recipients. Excel is not essential, but a prepared spreadsheet is often easier to check and maintain.

How do I make a separate letter for each recipient?
Choose Letters as the merge type, add the fields to the template, then use Finish & Merge > Edit Individual Documents. Word creates a new document containing the merged letters.

Can I mail merge labels in Word UK?
Yes. Choose Mailings > Start Mail Merge > Labels, select the label product number that matches your pack, insert the fields in the first label and select Update Labels. Preview and test-print before using a full sheet.

Will a Word mail merge send emails through Outlook?
Word’s Send Email Messages option can send individual merged emails using a configured desktop email account, commonly Outlook. Choose the correct address field and send a test first. The exact availability depends on your Word and email setup.

Can I change one letter after merging?
Yes. Select Finish & Merge > Edit Individual Documents, then edit the resulting document. Changes made there affect the merged output, not the original Excel list or the reusable Word template.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.