To use mail merge in Word with Excel data, prepare a spreadsheet with one recipient per row, connect it in Word through Mailings > Select Recipients > Use an Existing List, insert merge fields, preview the records, then choose Finish & Merge. You can use this process to create personalized letters, envelopes, labels, or email messages without typing each recipient’s details separately.
What You’ll Need
- A desktop version of Microsoft Word for Microsoft 365 and an Excel workbook containing the recipient data. Word for the web does not provide the full set of mail merge tools, so plan to complete the merge in the desktop app.
- A clearly organized Excel list: one header row, one recipient per row, and a separate column for each piece of information you may insert, such as first name, last name, email, street address, city, and postal code.
- A saved copy of the workbook in a location you can find. An .xlsx file is suitable. If it is stored in a cloud folder, make sure you can access it from the computer running Word.
- A Word document for the message or letter. You can start with a blank document, or select a mail merge document type in Word and build the layout there.
- For email merges, an email account configured in a supported desktop email program, typically classic Outlook for Windows. Availability and behavior can vary by Outlook version and organization settings.
Step-by-Step
- Prepare the Excel recipient list. Put column names in the first row, such as FirstName, LastName, Email, and City. Use a unique, clear header for each column, and avoid blank header cells, merged cells, and completely blank rows within the list. Keep each person’s information on one row. For example, if the first recipient is on row 2, their first name, last name, and email should all be on that same row. Remove test records and check spelling before connecting the file.
- Check how Excel stores the data. Make sure postal codes, phone numbers, and ID numbers that may begin with zero are stored so the zero is preserved. A numeric cell formatted to display a leading zero can sometimes arrive in Word without that display format. If the value is an identifier rather than a number for calculation, format the column as Text before entering or importing values, then verify the actual cell contents. For dates, use real Excel dates rather than a mixture of typed date styles. Save the workbook when you are done.
- Start the merge in Word. Open the document in desktop Word for Microsoft 365 on Windows. Select the Mailings tab, choose Start Mail Merge, and select the output type, such as Letters, E-mail Messages, or Labels. For a standard personalized letter, choose Letters. You can also begin with a blank document and choose the type before adding text. On Mac, use Word’s Mailings tab; the controls are similar, though their position and some dialog wording can differ slightly.
- Connect the Excel workbook. On Windows, go to Mailings > Select Recipients > Use an Existing List. Browse to the workbook and select it. If Word asks which sheet or named range to use, choose the one containing the list and confirm that the option indicating the first row contains column headers is selected. The precise dialog can vary based on the workbook. On Mac, select Mailings > Select Recipients and choose the option to use an existing data source, then locate the Excel file. If the expected sheet is not listed, check that the data is saved and arranged as a continuous table with headers.
- Choose or filter recipients. Select Mailings > Edit Recipient List to inspect the available records. Clear the checkbox beside anyone you do not want to include. Use the sorting or filtering controls in the recipient list dialog if you need a subset, such as recipients from one city. Check that the number and names of recipients make sense before continuing. Filtering here does not delete rows from Excel; it only controls which records Word uses for this merge.
- Write the main document. Type the parts of the letter that are the same for everyone, such as the greeting punctuation, message, closing, and signature. Leave the places that vary ready for merge fields. For example, you might type “Dear ” and then insert the first-name field after it. For an address block, leave room for the recipient’s name and address above the letter. Avoid manually typing a different copy of the letter for each person; the purpose of the main document is to hold the shared text and field positions.
- Insert fields from the spreadsheet. Click where a personal value should appear, then select Mailings > Insert Merge Field and choose the matching column header. You could place FirstName in the greeting, or insert City in a sentence about a local event. For a standard postal address, Mailings > Address Block can build an address from the available columns; use Match Fields in its dialog if Word does not recognize your headers. Greeting Line can insert a salutation based on name fields. Preview the result afterward, since automatic address and greeting formats may not suit every list.
- Preview several records. Select Mailings > Preview Results. Use the previous and next record arrows in the ribbon to check the first few recipients, a middle record, and the last record. Look for missing names, awkward spacing, incorrect addresses, and fields that display blanks or unexpected values. The field names shown before preview are placeholders; preview replaces them with data from each row. If something is wrong, turn preview off, correct the field or source data, and check again.
- Complete the merge. Choose Mailings > Finish & Merge. For letters, select Edit Individual Documents to create a new document containing the personalized copies, or choose Print Documents to send the merge directly to a printer. The edit option is useful when you want to review the complete output or make a one-off correction before printing. Choose whether to merge all records, the current record, or a range. Save the merged document with a clear name; it is separate from your original template.
- For labels or email, finish with the matching output settings. For labels, choose Mailings > Start Mail Merge > Labels, select the label vendor and product number that matches the packaging, insert fields in the first label, and select Update Labels to copy the layout across the sheet. Preview before printing, and print a test on plain paper to check alignment. For email, choose E-mail Messages as the merge type, insert fields in the message, then use Finish & Merge > Send E-mail Messages. Select the spreadsheet column containing email addresses, enter a subject, and choose the mail format. Send a test to yourself first. Email merging generally relies on a configured desktop email client and may be restricted by work or school policies.
Common Mistakes
Using multiple header rows. Word expects a single row of field names. Titles, notes, or blank rows above the headers can cause it to select the wrong range or treat the wrong row as column names. Keep the headers at the top of the data range.
Putting more than one person in a row. A row represents one recipient. If two recipients need separate letters, give them separate rows, even if they share a household address. Otherwise Word may treat their details as one record.
Assuming Excel’s visual formatting will transfer. Word may display a date, currency amount, or leading-zero code differently from Excel. Check the merged output rather than relying on how the source cell looks. Correct the source data or adjust the Word field formatting when needed.
Forgetting to update labels. In a label merge, inserting fields into the first label does not automatically guarantee that every label has the same layout. Use Update Labels, then preview multiple labels across the page.
Sending or printing without a review. A merge can generate many copies or messages quickly, including ones with blank fields or incorrect recipients. Preview records and make a small test output before processing the full list.
Tips
Convert the Excel list into a table before using it by selecting a cell in the data and choosing Insert > Table, then confirming that the table has headers. A table makes the recipient range easier to recognize and expand. Give the table a simple name if you will reuse it, and avoid adding totals or unrelated notes inside the recipient data.
Use separate columns for information you might need to place in different parts of a document. For example, FirstName and LastName are more flexible than a single FullName field if your greeting should use only a first name. Keep the field labels understandable to anyone who may maintain the workbook later.
For a large print run, first merge a small range of records and check the output. If you need a date such as “November 3, 2026,” check its appearance in Word’s preview. Word field codes can apply date or number formatting, but the syntax and result depend on the field and source. Do not assume that a cell’s Excel number format will control Word’s display.
Keep the Excel source, original Word template, and final merged file as separate files. That makes it easier to rerun a merge after correcting the list and reduces the risk of overwriting the reusable template. If you edit the Excel list after connecting it, save the workbook and refresh or reconnect the source in Word before relying on the new data.
Troubleshooting
Word cannot find the Excel file or sheet. Save the workbook, confirm that it is an Excel workbook rather than an unsaved copy, and reconnect through Mailings > Select Recipients. Check that the sheet has a header row and a continuous block of data. If the workbook is open and Word cannot read it, save and close Excel, then try selecting the file again. A file moved or renamed after the connection was created may need to be selected again.
Merge fields appear as names instead of real data. Turn on Mailings > Preview Results. If the fields remain blank, check Edit Recipient List to confirm that the correct sheet and records are selected. Reinsert the field from Insert Merge Field if its name does not match the Excel header.
Some merged values are blank or wrong. Compare the affected Word record with its Excel row. Look for empty cells, extra spaces, mismatched columns, or a filter that excluded the expected person. For date or number display problems, check the source value and preview the output again after adjusting the data or field formatting.
Only one label appears, or labels do not line up. Confirm that the selected label product number matches the physical label sheet. Insert fields in the first label, select Update Labels, and preview the full page. Print on plain paper and compare it with the label stock against a light before using actual labels. Check the printer’s scaling options if the test page is shifted or resized.
Email merge does not send. Confirm that the chosen recipient field contains valid email addresses and that Word is using an email application configured on the computer. Try sending a single test message. If the send option is unavailable or messages remain in an outbox, check Outlook setup and your organization’s mail policies; some environments block desktop mail merges or require a different approved sending method.
Frequently Asked Questions
Can I use an Excel file for a Word mail merge?
Yes. In desktop Word, choose Mailings > Select Recipients > Use an Existing List and select the workbook. Choose the sheet or range containing the recipient list, then insert fields from its column headers.
Can I do a mail merge in Word for the web?
Word for the web does not include the complete desktop mail merge workflow. Open the document in the desktop version of Word to connect the Excel list, preview records, and complete the merge.
Can I merge only selected people?
Yes. Open Mailings > Edit Recipient List, clear the checkboxes for people to exclude, or use the dialog’s filtering options to choose a subset. Preview the selected records before finishing.
Can I use Excel data for mailing labels?
Yes. Start a Labels merge, select the label vendor and product number that matches your sheets, connect the workbook, and add fields to the first label. Use Update Labels and preview the entire page before printing.
Will Word keep Excel’s date and number formatting?
Not always. Word may display the underlying value differently from Excel’s cell appearance. Check the Word preview and adjust the source data or Word field formatting if dates, currency, postal codes, or other values do not look right.
Can I save the merged letters separately from the template?
Yes. Choose Finish & Merge > Edit Individual Documents to create a new document with the selected personalized records. Save that output under a different name, leaving the original template available for future merges.
Related
- Excel Custom Number Format: How to Create and Apply It
- How to Select a Sheet in Excel With Keyboard Shortcuts
- Select in Excel Without Scrolling: Fast, Simple Methods
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Conditional Formatting Based on Value in Excel: Rules and ExamplesIn Excel for Microsoft 365 on Windows, select the cells you want to format, then choose Home >…
- How to Encrypt a Microsoft Excel File with a PasswordTo encrypt an Excel file in Microsoft 365 for Windows, open the workbook and choose File > Info…
- How to Strikethrough Numbers in Excel: Steps and TipsTo put a line through a number in Excel for Microsoft 365 on Windows, select the cell and…
- Excel File Format Corrupted? Causes, Fixes, and RecoveryIf Excel says a file format or file extension is invalid, or a workbook will not open, the…
- How to Enable Merge and Center in Excel: Quick FixesIn Excel for Microsoft 365 on Windows, select the cells you want to combine, then choose Home >…
- How to Design a Brochure in Word: Layout, Panels, and PrintTo design a brochure in Word, set up a landscape document with two pages, arrange each page as…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.