Mail Merge Excel to Word: A Practical Step-by-Step Guide

To mail merge Excel data into Word, prepare a workbook with one row per recipient and a header for each data field, then in Word choose Mailings > Start Mail Merge, connect the workbook through Select Recipients > Use an Existing List, insert merge fields, preview the results, and choose Finish & Merge. The merge uses each spreadsheet row to create a personalized letter, label, envelope, or email.

What mail merge does

Mail merge joins a main document in Word with a recipient list, such as an Excel workbook. The Word document contains the shared wording and merge fields; the spreadsheet supplies the changing details. For example, a letter can use the same message for everyone while inserting each person’s name, address, appointment date, or order number from their row.

Each data row represents one recipient or record, and each column represents a type of information. A column heading such as FirstName or PostalCode becomes a field Word can insert. Word then combines the template with selected records to make separate personalized outputs. This is different from copying a table into Word: the linked list supplies values to placeholders in a document.

Mail merge is useful for routine communications, but it does not independently verify the data or decide what should be sent. Incorrect addresses, misspelled names, or wrongly matched dates in Excel can carry through to the finished documents, so checking the source and preview matters.

Prepare the Excel recipient list

Before connecting the workbook, make the data predictable. Store the recipient list on its own worksheet and use a single header row followed by records. Avoid blank rows or columns within the list, merged cells, and multiple unrelated tables on the same worksheet. These precautions help Word identify the data range cleanly.

Use clear, unique column names, such as FirstName, LastName, Street, City, PostalCode, and EmailAddress.
Put one complete recipient or record on each row. Keep related details together on that row so names and addresses do not become mismatched.
Keep a consistent type of information in each column. Do not mix dates with notes or postal codes with unrelated text.
Save the workbook as an Excel file, such as .xlsx, and save changes before connecting it to Word.

Pay particular attention to values Excel may reinterpret. Postal codes, account numbers, and phone numbers can contain leading zeros or punctuation that should be preserved. Format those columns as Text before entering or importing the values; changing the format after Excel has removed a leading zero does not restore it. For dates, use genuine Excel date values rather than a mixture of typed date strings, and choose a date format that makes the intended day and month clear.

For a simple example, one row might contain Jamie, Patel, 18 Oak Street, Bristol, BS1 4AA, and jamie@example.com under the matching headings. In a Word letter, fields for the first name and address can draw from that row. Keep the headings descriptive rather than relying on labels such as Column1, because recognizable field names make the document easier to build and check.

Connect Excel to Word

These steps are for Microsoft 365 Word on Windows. Open the Word document that will serve as the template, or start a new document. On the Mailings tab, choose Start Mail Merge > Letters if you are preparing letters. For labels, envelopes, or email messages, select the corresponding type instead; Word changes the setup options to suit that output.

On Mailings, choose Select Recipients > Use an Existing List.
Browse to the saved Excel workbook and select it. If Word asks which table or worksheet to use, choose the sheet containing the list, often shown with a dollar sign after its name.
Confirm that the first row contains column headings if Word presents that option, then select the recipient list or range.
Choose Mailings > Edit Recipient List to review the records. You can usually select or clear recipients and sort or filter the list for the current merge.

If the workbook has multiple worksheets or named ranges, choose the one containing the intended records. For the least confusing setup, close the workbook in Excel before connecting it, and avoid renaming or moving the source file while building the merge. Word for Mac also has mail-merge tools on the Mailings tab, although dialog wording and layout can differ slightly. Word for the web is not a full substitute for desktop Word for creating and completing mail merges; use the desktop application for the merge workflow.

Insert fields and build the document

Write the wording that should appear in every output, leaving space where recipient-specific details belong. Place the insertion point at the right location, then use Mailings > Insert Merge Field and select a heading from the Excel list. For an address block, Word also offers Address Block; Greeting Line can create a salutation from available name fields. These tools are convenient, but inspect their output because field names and address conventions vary between lists.

A simple letter might begin with an address block, followed by a greeting such as Dear and a FirstName merge field, then the shared message. You can insert additional fields in the body, for example an appointment date or reference number. Ordinary text remains the same for each recipient; merge fields are replaced with the corresponding row’s values.

For labels, use Mailings > Start Mail Merge > Labels, select the label product or enter the label dimensions, connect the recipient list, and insert fields into the first label. Choose Update Labels to copy the layout across the sheet. Check the label stock and printer settings before printing, since a mismatch in label size or margins can shift the output.

Preview, filter, and finish the merge

Choose Mailings > Preview Results to view the document with actual recipient values in place of the field names. Use the navigation arrows on the Mailings tab to check several records, not just the first one. Confirm that long names fit, punctuation reads naturally, dates appear as intended, and no field is blank where a value is expected.

To make a merge for only some recipients, choose Edit Recipient List and use its selection, sorting, or filtering controls. For instance, a list containing customers in several regions can be filtered to one city before producing a local mailing. Filtering the merge does not necessarily delete rows from Excel; it controls which records Word uses for that merge.

When the preview is correct, choose Finish & Merge. Edit Individual Documents creates a new Word document containing the merged records, which is useful when you want to inspect or save the complete result before printing. Print Documents sends the results to the printer. For email merges, choose Send Email Messages, select the column containing email addresses, enter a subject line, and choose the desired mail format. Email merging sends separate personalized messages rather than one message with all recipients exposed in a shared To line. It does not attach files automatically.

For a first run, merge to a new document or print a small test selection rather than sending or printing the entire list immediately. Review the output, then return to the source and template to correct any problems. If sending email, verify the recipient field and subject, and confirm that the configured desktop email application can send the messages.

Common problems and practical fixes

Word does not show the expected worksheet. Save the workbook, check that the list is laid out as a single table with headings, and reconnect to the correct worksheet or range. Close Excel before selecting the workbook if the connection seems stale.
A merge field is blank or displays an unexpected value. Check the corresponding Excel column and the selected records. A blank cell in the source normally produces a blank field in Word; Word cannot supply missing information.
Postal codes lose leading zeros. Store codes as text in Excel and confirm they display correctly before connecting the list. If the zeros were already removed, correct the source values first.
Dates or numbers look different in Word. Preview the merged result instead of assuming it will match the worksheet’s display format. If the result needs a different date presentation, adjust the Word field formatting or prepare a clearly formatted text column in Excel, then preview again.
Only one recipient appears. Check Preview Results navigation and the recipient selection in Edit Recipient List. Also confirm that the chosen Excel range includes all intended data rows.
Labels repeat the same recipient. After arranging the first label, use Update Labels so Word inserts the record progression for the rest of the sheet; preview multiple labels before printing.

When troubleshooting, separate source problems from layout problems. If a value is wrong in Excel, fix the workbook. If the value is right in Excel but poorly placed or formatted in the merged document, adjust the Word template or field presentation. This prevents repeated edits to the wrong part of the workflow.

Mail merge choices, compatibility, and privacy

Excel is a practical source when the recipient list is already maintained as a spreadsheet, because its columns map naturally to merge fields. A CSV file can also work as a simple data source, but it does not preserve workbook formatting or multiple worksheets. Outlook contacts can be a better source when the records are maintained there, while a manually maintained Word list may suit a very small, one-time mailing. Choose the source that is accurate and easiest to maintain; the merge process still needs a review whichever source you use.

Mail merge is a feature of desktop Word, but availability depends on the Office edition and account or organization license. There is not normally a separate per-merge fee; check the Microsoft 365 plan or workplace software access for the desktop Word application. Email sending can also depend on a compatible, configured email program and organizational policies. If Word cannot send a merge, use an approved email workflow rather than assuming the document itself has delivered anything.

Recipient lists may contain personal information. Keep the workbook and merged output in approved storage, limit access to people who need it, and remove temporary files when they are no longer required under your organization’s rules. Before printing, mailing, or emailing, verify recipients, attachments or enclosures, and the information shown in each record. A correct merge can still disclose information if the wrong source list or recipient field is selected.

Frequently Asked Questions

Can I mail merge Excel data into Word?
Yes. In desktop Word, select Mailings > Start Mail Merge, connect the workbook with Select Recipients > Use an Existing List, insert fields, preview the records, and finish the merge.

Does the Excel workbook need to be open?
No. Save the workbook before connecting it. Closing it in Excel can make the connection easier to manage, especially if you need to change the source or Word is not showing recent edits.

Can I use Excel to make address labels in Word?
Yes. Choose the Labels merge type, select the label layout, connect the Excel list, insert the address fields in the first label, and use Update Labels. Print a test on plain paper to check alignment before using label stock.

Can Word mail merge send personalized emails?
Yes. Choose the email message merge type and use Send Email Messages, selecting the Excel column that contains each address. The messages are sent individually, and this workflow does not automatically include file attachments.

Why does Word show the wrong date or postal code?
Word uses the underlying source value, and some values may not display in the merged document exactly as they appear in Excel. Store postal codes with leading zeros as text, use real date values where appropriate, and inspect Preview Results before completing the merge.

Can I complete a mail merge in Word for the web?
Use desktop Word for the full process of setting up and completing a mail merge. Word for the web can be useful for working with documents, but it does not provide the same full mail-merge workflow as the desktop application.

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.