To mail merge Excel to Word, prepare your recipient list in Excel, then in Word choose Mailings > Start Mail Merge, select a document type, and use Select Recipients > Use an Existing List to connect the workbook. Insert merge fields, preview the records, and choose Finish & Merge to create letters, labels, or email messages.
What mail merge does
Mail merge combines a Word document with a data source. The Word file supplies the shared text and layout; each record in the Excel list supplies the details that change, such as a person’s name, address, appointment date, or account reference. Word then produces a personalized version for each selected record.
For example, a workbook might contain one row per customer and columns named FirstName, LastName, Street, City, and AppointmentDate. A Word letter can contain ordinary text plus fields such as «FirstName» and «AppointmentDate». During the merge, Word replaces each field with the value from that person’s row. The column headers identify the available fields, and the rows below them represent recipients.
Mail merge is useful when the message or document is mostly the same for many people. It does not automatically make a document appropriate for every recipient: the shared wording, chosen recipients, and inserted information still need to be checked.
Prepare the Excel recipient list
A clean source workbook makes the Word steps much more reliable. Keep the data in a simple rectangular list, with one header row and one recipient per row. For instance, do not put a report title above the headers or add totals and notes beneath the records in the same data range. Those extra rows can be mistaken for records or make the table harder to select.
- Give every column a short, distinct header, such as FirstName, PostalCode, or EmailAddress. Avoid blank or duplicate headers.
- Put one kind of information in each column. Keep first and last names separate if the letter needs to address people by first name.
- Remove completely blank rows and columns inside the list. A blank row can interrupt the range Word detects.
- Use actual Excel dates for dates and consistent values for categories such as state or country. Check that dates are not a mixture of real dates and text.
- Save the workbook in a location you can find, such as a local folder or a stable shared location, before connecting it to Word.
Excel formatting and the underlying value are not always the same thing. A postal code such as 00427 may lose its first zero if Excel treats it as a number. Store identifiers and postal codes that need leading zeros as text, or set the column to Text before entering or importing the values. Similarly, phone numbers are generally better treated as text than as quantities to calculate.
If the list is already an Excel table, that can make its boundaries clearer. Select the data and use Insert > Table, making sure My table has headers is selected. A normal, consistently structured range can also work. Save and close the workbook before linking it, especially if Word cannot read it or the file is being edited by another process.
Connect Excel to Word and insert fields
In Word for Microsoft 365 on Windows, open or create the document that will become the merge template. Use these steps for a standard letter:
- Go to Mailings > Start Mail Merge > Letters. For a different output, choose the relevant type, such as E-mail Messages or Labels.
- Select Mailings > Select Recipients > Use an Existing List. Browse to the Excel workbook and open it.
- If Word asks which table or sheet to use, select the one containing the list. Confirm that the option indicating the first row contains column headers is enabled when shown.
- Write the shared text of the letter. Place the cursor where personalized information should appear, then choose Mailings > Insert Merge Field and select the appropriate column name.
- Use Mailings > Preview Results to view the template with actual records. The record navigation controls let you check more than the first recipient.
- Choose Mailings > Finish & Merge, then select an output action, such as editing individual documents, printing, or sending email messages.
Use Word’s Address Block or Greeting Line options if their proposed layout suits the source data, but inspect the result. If the source uses unusual header names or separates address parts differently, inserting individual fields gives you more control. Field names in the document are placeholders, not proof that the source values are complete or correctly matched.
On Word for Mac, the Mailings tab provides the corresponding mail-merge tools, though some dialogs and recipient-selection screens can look different from Windows. Word for the web has more limited desktop publishing features; use the desktop Word application for the full mail-merge workflow. Excel for the web can be used to prepare or edit a workbook, but it is Word—not Excel—that creates the merged document.
Choose the right merge output
The document type determines how Word lays out the result. Letters are the typical choice for personalized notices, invitations, and statements. Word can generate a combined document with a page or section for each record, or send the completed pages to a printer. Use labels when you want recipient details placed into a label layout. Select the label manufacturer and product number that match the physical label sheets; choosing a similar-looking but incorrect layout can misalign the printout.
Email merges create an individual message for each selected recipient rather than one message addressed to everyone. In the email merge dialog, select the column containing email addresses, enter a subject line, and choose the message format offered by Word. A mail merge email is not the same as attaching a personalized Word or PDF file to each message; Word’s standard email merge sends the merged text as the message body. Email sending depends on a compatible configured desktop email setup, and the available behavior can vary with the installed Outlook version. Check the recipient list and test the message before sending a large batch.
For a first run, Finish & Merge > Edit Individual Documents is often the safest choice. It creates a separate result document containing the merged records, so you can review the actual wording and page breaks before printing. The original template remains useful for later runs, while the generated document contains the results rather than editable links to each Excel row.
Control recipients and review the result
You do not have to send or print every row in the workbook. Choose Mailings > Edit Recipient List to inspect the selected records, sort or filter them, and clear the check box for a recipient you want to exclude. This is useful for a one-time subset, such as customers in one region. If the same filtering is needed repeatedly, making a clearly named filtered table or separate source list can make the process easier to audit.
Preview several records, including the first and last selected records and any rows with unusual or optional values. Check that names are not blank, addresses have sensible line breaks, and the greeting still reads naturally for every recipient. Also verify the number of selected recipients and the number of resulting pages or messages. One recipient may produce multiple pages, so page count is not necessarily the same as recipient count.
For sensitive or high-impact communications, review the merged output as a document, not just the template. A correct-looking placeholder can conceal a bad source value, and an incorrect filter can include people who should not receive the message. Keep the recipient file in an appropriately protected location and avoid sharing merged documents containing personal information more widely than needed.
Fix common formatting and connection problems
A frequent surprise is that Word does not display a date, number, or currency exactly as it appears in Excel. For example, a date stored in Excel as a date value may appear in Word in a different date style. First confirm that the source column contains consistent values. Then format the merge field in Word if you need a particular presentation. Right-click a merge field and choose Toggle Field Codes to inspect its field instructions; a date field can use a date-format switch, and a numeric field can use a number-format switch. Toggle the codes back and update or preview the field to check the result. The field’s appearance depends on the actual source value and the format you specify.
If Word shows field names rather than personalized values, make sure Preview Results is turned on. If it uses the wrong worksheet, reopen Select Recipients and choose the correct sheet or table. If a header is missing from Insert Merge Field, check that the column has a header and that Word connected to the right range. Save the Excel file after editing it, and reconnect or refresh the recipient source if Word continues to show old data.
Other common fixes include:
- Leading zeros disappear: store the source column as text and confirm the values themselves include the zeros.
- Blank fields create awkward gaps: check for missing source data and adjust the template wording or address layout. Optional values may need a different template or carefully managed conditional rules.
- Only one record appears: check the selected recipient range and use the record navigation controls in Preview Results. A filter may have reduced the list to one row.
- The wrong records merge: reopen Edit Recipient List, inspect filters and selections, and verify the source sheet and headers before finishing.
- Labels do not line up: confirm the label product number, print settings, paper size, and printer scaling. Print a test on plain paper and compare it with the label sheet before using the labels.
Excel mail merge versus alternatives
Excel is convenient when the recipient data already lives in a spreadsheet or needs spreadsheet-style sorting and cleanup. Word’s mail merge is suited to repeatable, document-based output, particularly when each recipient needs a letter, label, or customized message. It is not a database system: it does not replace data validation, access controls, or a careful process for deciding which records are correct and current.
For a small number of documents, copying information manually may be quicker, but it increases the chance of inconsistent names, addresses, and dates. For recurring campaigns, customer records, or complex approval workflows, a contact-management or customer-relationship-management system may provide stronger record management and sending controls. If recipients need a personalized attachment rather than a personalized email body, a dedicated document-generation workflow or an appropriate add-in may be needed; confirm that it supports your Word and Outlook versions before relying on it.
Mail merge itself is part of the desktop Office applications, but access to Word, Excel, and email features depends on the Microsoft 365 plan, installed apps, account, and organization settings. A work or school administrator may restrict connected files or bulk email. No separate Excel formula is required to create a basic Word merge.
Frequently Asked Questions
Can I mail merge from Excel to Word without Outlook?
Yes, for letters, labels, and documents: Word can connect to an Excel list and create or print the merged output without sending email. Sending a mail-merge email requires a compatible desktop email setup; the available options depend on the email application and its configuration.
Does Word automatically update when I change the Excel list?
Do not assume that an open merge document immediately reflects every workbook edit. Save changes in Excel, then check the Word recipient connection and preview the records again. If the source has moved or Word is showing stale data, select the workbook again through Select Recipients.
How do I mail merge only selected Excel rows?
In Word, open Mailings > Edit Recipient List and use its selection or filtering options to include only the desired records. Preview the results before choosing Finish & Merge so you can catch an unintended filter or selection.
Can I use an Excel file with multiple sheets?
Yes. When you connect the workbook, Word may ask which sheet or table to use. Choose the one with the header row and recipient records. Keeping each mail-merge list in a clearly named, consistently structured sheet makes the correct choice easier.
Why does Word change my Excel date or number formatting?
Word may read the underlying value without reproducing Excel’s displayed format. Check that the source value is the intended type, then adjust the merge field’s format in Word if necessary. Preview multiple records because mixed text and numeric values can produce inconsistent results.
Related
- Insert Image in Excel: Steps, Options, and Tips
- Excel Text to Number: Reliable Ways to Convert Values
- Excel Find and Replace: Change One Word to Another Quickly
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Create a Booklet in Microsoft WordTo create a booklet in Microsoft Word, open the desktop app, go to Layout > Margins > Custom…
- How to Accept All Track Changes in WordTo accept every tracked edit in a Word document, open the Review tab, open the Accept menu, and…
- Excel New Blank Workbook: Create, Save, and Set It UpTo create a new blank workbook in Excel for Microsoft 365 on Windows, press Ctrl+N, or select File…
- How to Change the Color Scheme in Excel and Save ItIn Excel for Microsoft 365 on Windows, go to Page Layout > Themes > Colors and choose a…
- Google Sheets Filter Shortcut: Apply a Filter FastIn Google Sheets in a web browser, press Ctrl+Shift+L on Windows, Linux, or ChromeOS to create a filter;…
- Draw.io Table Merge Cells: Steps and Common ProblemsYes. In draw.io (now also called diagrams.net), you can merge adjacent cells in a native table: select the…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.