Excel mail merge uses an Excel workbook as a recipient list and Microsoft Word to create personalized letters, labels, envelopes, or email messages. In Word for Microsoft 365 on Windows, prepare a clean Excel table, then choose Mailings > Start Mail Merge and Mailings > Select Recipients > Use an Existing List to connect it.
What Excel mail merge means
Excel does not have a general-purpose mail-merge command that automatically creates a separate letter or message for each row. Instead, Excel stores and organizes the information, while Word uses that information to fill in a document template. A column might contain first names, another postal addresses, and another an order or appointment detail. Each row represents one recipient or record.
This division of work is useful because Excel is well suited to maintaining structured lists, while Word can lay out documents and insert fields into sentences. A template might say, “Dear” followed by a first-name field, and then refer to an appointment date from the same row. Word repeats the template for the selected records, replacing each field with the corresponding value.
Mail merge is not the same as copying a spreadsheet range into a Word document. A pasted range shows the table itself; a merge uses row values to produce individualized output. It also does not automatically guarantee that a message reaches its recipient: email delivery depends on the email application, account, and sending setup.
Prepare the Excel recipient list
Start with one worksheet arranged as a simple table. Put field names in the first row and one record in each subsequent row. For example, a letter list could have columns named FirstName, LastName, Address, City, State, PostalCode, and AppointmentDate. Keep each type of information in its own column: separate first and last names if you want to address people by first name, and separate street, city, and postal code if you need to place those values independently.
- Use a distinct, descriptive heading for every column. Avoid blank headings, duplicate names, and headings that span multiple cells.
- Keep the list contiguous, without blank rows or columns breaking it into separate blocks. Remove merged cells from the data area.
- Check for empty records, accidental duplicate recipients, spelling errors, and inconsistent values such as “CA” in some rows and “California” in others.
- Format postal codes, account numbers, and other identifiers as text when leading zeros matter. Excel may otherwise interpret a value such as 00421 as the number 421.
- Save the workbook in a location you can find, and close it before connecting to it in Word. Closing it can help avoid file access or update issues.
For an ongoing list, you can turn the data range into an Excel table using Insert > Table, then confirm that the table has headers. A table is easier to extend as records are added, though a straightforward, clean range can also work as a data source. Keep the recipient data on a clearly named worksheet so it is easy to select the right sheet when Word asks.
Connect Excel to a Word document
Open or create the Word document that will serve as the template. For a letter in Word for Microsoft 365 on Windows, use this sequence:
- Choose Mailings > Start Mail Merge > Letters.
- Choose Mailings > Select Recipients > Use an Existing List.
- Browse to the Excel workbook and select it.
- In the data-source dialog, select the worksheet or table that contains the recipient list. If the first row contains headings, confirm the option indicating that the first row contains column headers.
- Place the cursor where personalized information should appear, then choose Mailings > Insert Merge Field and select the relevant heading.
You can insert fields into a greeting, an address block, or the body of a letter. For example, a template can begin “Dear” followed by the FirstName merge field, and include a second field for AppointmentDate later in the paragraph. Type ordinary punctuation and spaces around the fields as needed. The field is a placeholder: it will display a recipient’s actual value in the merged result.
Word for Mac has a Mailings tab and supports mail merge, but the exact dialogs and available options can differ from Windows. Excel for the web is useful for editing the workbook, but the merge workflow described here is performed in the desktop Word application. If you cannot find a command, check that you are using desktop Word and that the Mailings tab is available.
Preview records and choose who receives the merge
Before generating anything, choose Mailings > Preview Results. Word replaces the field names with values from the selected record. Use the previous and next record controls on the Mailings tab to inspect several rows, including the first and last records. Check names, spacing, punctuation, address lines, and dates rather than assuming that a correct-looking first record means the entire list is sound.
To restrict the output, choose Mailings > Edit Recipient List. From there, you can sort or filter the available records and clear the check box next to a recipient who should be excluded. This is useful when a workbook contains several groups or when you want to send a test to a small subset. Filtering the merge does not delete rows from the Excel workbook; it changes which records Word uses for that merge.
A practical test is to make a small copy of the list with two or three representative records. Include cases that might cause layout problems, such as a long name, a missing optional value, or a postal code with a leading zero. Preview these before producing a large batch. If a field is blank, revise the source data or adjust the wording so the template still reads naturally when that field has no value.
Create letters, labels, and email messages
The selected merge type determines how Word uses the records. Letters are suited to personalized documents, such as notices or appointment reminders. Choose Mailings > Start Mail Merge > Labels to set a label vendor and product number, then insert fields in the first label and use Update Labels to repeat the layout across the page. Check the result in Print Preview and compare the selected product number with the labels you actually have; a mismatch can shift text onto the wrong label.
Envelopes are another option in the Start Mail Merge menu. They let you position recipient fields on an envelope layout, but you should verify the envelope size and printer settings before printing a full batch. For any output type, choose Mailings > Finish & Merge to see the available actions. Edit Individual Documents creates a new document containing the merged records, which is often a sensible way to review the complete output before printing. Print Documents sends the result to a printer.
For email, choose Mailings > Start Mail Merge > E-mail Messages. Insert the personalized text, then choose Finish & Merge > Send E-mail Messages. In the dialog, select the column containing email addresses, enter a subject line, and choose a mail format. Word’s email merge sends individual messages rather than placing every recipient in one visible To or Cc line, but sending depends on a compatible, configured email application. Test with a small number of addresses first, and confirm that the correct account and recipient column are selected.
Handle dates, numbers, and missing values
One of the most common surprises is that a date or number appears differently in Word than it does in Excel. Excel’s cell display format does not always carry through as expected in a merge. A date might appear as a serial value or in a format that does not suit the letter. First check the source cell and the preview; then adjust the Word merge field’s formatting if necessary.
In Word, press Alt+F9 on Windows to show field codes, locate the relevant merge field, and add a formatting switch. For example, a date field can be formatted with a code like { MERGEFIELD AppointmentDate \@ "MMMM d, yyyy" }, which displays a date such as March 8, 2026. The braces around a field are Word field braces, not ordinary typed braces; use the existing merge field rather than replacing it with text. Press Alt+F9 again to return to the regular view, then preview the result. On Mac, the corresponding field-code shortcut may differ by keyboard and Word version; use Word’s field-code controls or check the shortcut shown for your installation.
For values that must retain leading zeros, storing them as text in Excel is often safer than relying on a display format. For currency or other quantities, confirm that the intended decimal places and symbols appear in the Word preview. If an optional field is blank, consider whether the sentence needs to change; a merge does not automatically remove surrounding words or punctuation just because a field has no value.
Common problems and how to fix them
- The wrong worksheet or range appears: Reconnect using Select Recipients and choose the worksheet or table that has the actual headings and records. Check that headings are in the first row of the selected data.
- A column is missing from Insert Merge Field: Save and close the Excel workbook, confirm the heading is not blank or duplicated, then reconnect to the correct data source.
- Leading zeros disappear: Store identifiers such as postal codes as text in Excel, then reconnect and preview. A number format that only changes how a number looks may not be sufficient for every merge setup.
- Dates or amounts look wrong: Inspect the value in Excel and the Word preview. Use a Word field-format switch where appropriate, then preview several records.
- Labels do not line up: Confirm the label vendor and product number, check the printer’s paper and scaling settings, and print a test on plain paper before using label stock.
- Email is unavailable or does not send: Verify that Word has a compatible email application and account configured, and test a few messages. Check for an incorrect email-address column, unsent messages, or delivery restrictions.
Many merge errors come from the source data rather than Word. A quick review of headings, blank rows, data types, and representative records can prevent a much larger reprint or a message sent with the wrong information.
Mail merge alternatives, cost, and privacy
For a small number of documents, manually copying a few details into a Word template may be quicker than setting up a merge. For repeated letters, labels, or notices, Excel plus Word offers a repeatable workflow using the Microsoft 365 desktop apps; there is generally no separate mail-merge fee beyond access to the applications. Microsoft 365 plans and feature availability can change, so check the license associated with your organization or account.
For large marketing campaigns, services designed for bulk email may offer subscription management, delivery reporting, and tools for handling opt-outs. Those are different needs from creating a few personalized emails in Word. Compare the service’s current pricing, sending limits, data practices, and suitability for your use before uploading a contact list. A merge also does not replace the need to follow applicable rules for sending messages; seek qualified guidance if you are unsure about your obligations.
Treat the workbook as personal or business data if it contains names, addresses, or other identifying details. Store it only where authorized people can access it, avoid leaving unnecessary copies in shared folders, and double-check recipients before sending or printing. When testing, use dummy records or a small, approved sample rather than exposing a full contact list unnecessarily.
Frequently Asked Questions
Can you do a mail merge directly in Excel?
Excel can organize and supply the recipient data, but the standard Microsoft 365 workflow uses Word to create merged letters, labels, envelopes, or email messages. Excel alone does not produce that Word mail-merge output.
Do I need to format my Excel data as a table?
No. A clean, contiguous range with clear headings can work. An Excel table can make an expanding list easier to manage, but the important points are a header row, one record per row, and no structural gaps or merged cells in the data.
Can Excel mail merge send personalized emails?
Yes, Word can use an Excel list for an email merge through Mailings > Start Mail Merge > E-mail Messages. You need a compatible configured email setup, and you should test a small batch before sending to the full list.
Why are dates wrong in my Word mail merge?
Word may not display a date using the same format you see in Excel. Preview the field and, if needed, add a Word date-format switch to its merge field. Also confirm that the source cell contains a valid date rather than text that only looks like one.
Can I use mail merge for labels?
Yes. Choose Labels as the merge type, select the label product that matches your stock, insert fields, and use Update Labels. Preview the pages and test the alignment on plain paper before printing on the actual labels.
Related
- Text to Date in Excel: Convert Dates Stored as Text
- Search an Excel Column for Matching Text
- Search Excel for Duplicate Entries: Methods That Work
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Large Excel File Won’t Open? Causes and Practical FixesIf a large Excel file won’t open, first copy it to a local drive, close other programs, and…
- How to Make a Flowchart in Word 2019, Step by StepTo make a flowchart in Word 2019, choose Insert > Shapes, select a flowchart shape, and draw it…
- How to Insert a Drop-Down Checkbox in Excel CellsTo make a drop-down checkbox in Excel, create a Data Validation list containing unchecked and checked symbols, then…
- Excel Time Format Over 24 Hours: Display Elapsed Time CorrectlyTo display a duration longer than 24 hours in Excel, select the cells, open Format Cells, choose Custom,…
- Calculated Field in a PivotTable: How It WorksA calculated field in an Excel PivotTable is a custom calculation made from fields in the source data,…
- How to Close Track Changes in WordTo close Track Changes in Word, open the Review tab and select Track Changes to turn it off.…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.