How to Mail Merge From Excel to Word: Step-by-Step Tutorial

Knowing how to mail merge from Excel to Word is one of the highest-leverage office skills you can pick up. Mail merge takes a list of recipients in an Excel spreadsheet and automatically generates personalized letters, envelopes, labels, or emails in Word — one for each row. Instead of typing 200 letters by hand, you write one template, point Word at your Excel list, and Word produces 200 customized documents in seconds. The skill scales from holiday cards to mass mailings to bulk invoices and beyond.

This guide walks through the full process end to end. We'll cover preparing the Excel data source so Word can read it cleanly, starting the mail merge wizard in Word, selecting the recipient list, inserting merge fields into your template, previewing the merged documents, completing the merge, and troubleshooting the most common issues — date formatting, number formatting, and special characters that don't transfer cleanly between the two applications.

The instructions here apply to Excel and Word in Microsoft 365, Office 2019, Office 2021, and the older standalone versions. Menu placements vary slightly between Windows and macOS, and we note the differences where they matter. Mail merge in Word for the Web is more limited; for serious mail merge work the desktop applications remain the best choice. Most people who get stuck do so on the data preparation step, so we spend extra time on that early section.

By the end of this guide you should be able to mail merge from Excel to Word for letters, envelopes, labels, and email messages. You'll also know how to fix the formatting glitches that catch first-time users — dates that show as serial numbers, ZIP codes that lose leading zeros, currency that loses dollar signs, and percentages that suddenly appear as long decimals. Each of those has a specific cause and a specific fix that we cover below.

Mail merge has been part of Microsoft Office since the 1990s. Despite the introduction of newer tools (Power Automate, dedicated mass-mail platforms, marketing automation suites), the Excel-to-Word workflow remains the most accessible option for most users. It requires only the Office applications you probably already have, no internet connection during the merge itself, and a learning curve that takes about 30 minutes from zero to functional. That accessibility is why it's still the dominant tool for personalized correspondence in offices, schools, churches, and small businesses.

Step 1 — prepare your Excel data source

The single most important step is structuring the Excel spreadsheet correctly. Word reads your Excel data as a flat table, so the spreadsheet must follow simple rules. Put column headers in row 1 — names like FirstName, LastName, Address1, City, State, ZIP. Each column header becomes a merge field name in Word. Put the data starting in row 2, one recipient per row. Avoid spaces and special characters in the column headers themselves — Word handles them but errors are easier to debug with clean header names.

Save the workbook as a regular .xlsx file. The data should be on the first sheet, and the active range should start in cell A1. Don't add titles, blank rows above the data, or merged cells — those break the merge or produce unexpected results. If your real data has those structural issues, copy the raw rows into a separate clean sheet specifically for the mail merge and use that sheet as the data source. Many people spend hours debugging weird merge errors that trace back to a merged cell or a blank row at the top of the spreadsheet.

Pay attention to data types in Excel before merging. Dates stored as serial numbers will appear as numbers in Word. ZIP codes stored as numbers will lose leading zeros. Currency values lose dollar signs. Percentages become decimals. The cleanest fix is to format the cells as Text in Excel before entering the data, which preserves exactly what you typed. Alternatively, you can use Word's field-switch syntax (covered later in this guide) to format the merged data inside Word during the merge.

One more preparation step worth doing: sort your data the way you want the output to appear. Mail merge processes rows in the order they appear in the spreadsheet, so if you want letters printed in ZIP-code order or alphabetical by last name, sort the spreadsheet first. You can also filter rows during the merge using Word's recipient list filter, but pre-sorting in Excel is faster for one-time merges where you know the desired output order before you start the process.

Step 2 — start the mail merge in Word

Open Word and either create a new blank document or open an existing letter template you've already drafted. From the Word ribbon, click the Mailings tab. The Mailings tab contains all the mail merge tools. Click Start Mail Merge and choose the document type — Letters, Envelopes, Labels, or Email Messages. Each type configures Word slightly differently, so picking the right one upfront saves time. For most use cases, Letters is the right choice and produces a Word document with one personalized page per recipient.

Next, click Select Recipients and choose Use an Existing List. Browse to your Excel file and click Open. Word displays a Select Table dialog listing each sheet in the workbook. Pick the sheet containing your data (usually Sheet1) and confirm that First row of data contains column headers is checked. Click OK. Word now has your Excel file connected as the data source for this mail merge document.

Word remembers the data source connection. The next time you open the same Word document, it will prompt you to confirm or refresh the connection to the Excel file. If you change the Excel data, the mail merge will pick up the latest version on the next refresh. This means you can iterate — fix data, refresh in Word, regenerate documents — without having to redo the whole connection setup each time. The same template can be reused across multiple monthly or quarterly mailings without rebuilding from scratch.

Step 3 — insert merge fields into your template

Now type or paste your letter text in the Word document. Wherever you want a personalized field — the recipient's name, address, account number, or any other data from your Excel sheet — click the spot in your template, then click Insert Merge Field on the Mailings tab. Word displays a dropdown list of every column header from your Excel file. Click the field you want, and Word inserts a placeholder like <<FirstName>> that will be replaced by the actual value during the merge.

For addresses, Word provides a convenient shortcut called Address Block. Click Address Block on the Mailings tab to insert a properly formatted multi-line address with name, street, city, state, and ZIP all in one step. Word automatically maps your Excel columns to the standard address parts. If the auto-mapping is wrong (because your column headers use unusual names), click Match Fields in the Address Block dialog and manually map each part to the right column.

Greeting Line works similarly for the salutation. It inserts a line like "Dear Mr. Smith," or "Dear Jane," using the recipient's name fields from Excel. The dialog lets you choose the format (formal vs. casual) and the fallback text for recipients with missing name data. The fallback matters — if even one row lacks a first name, the merge would otherwise produce "Dear ," which looks unprofessional and signals immediately that this was an automated mailing.

You can mix merge fields with regular text freely. A donation thank-you letter might read: "Dear <<FirstName>>, thank you for your gift of <<Amount>> to support our work. Your contribution will help us serve <<NumberOfClients>> clients this year." Word replaces each << >> placeholder with the value from that recipient's row in Excel. Format the merge field text the same way you'd format any other text — bold, italic, color, font — and Word preserves that formatting in the merged output.

Step 4 — preview and complete the merge

Once your template is ready, click Preview Results on the Mailings tab. Word replaces each merge field with the actual value from the first row of your Excel data, showing you what the final document will look like for that recipient. Use the navigation arrows on the Mailings tab to step through each recipient and verify the merge looks right. Pay special attention to addresses, dates, currency, and any conditional fields that vary based on row data — those are where formatting glitches show up first.

If the preview looks wrong, fix the issue before completing the merge. Wrong address mapping? Re-do the Address Block with corrected Match Fields. Date showing as a serial number? Add a field switch. Recipient list includes people you don't want? Click Edit Recipient List on the Mailings tab and uncheck the rows you want to skip, or add a filter to include only specific groups. The recipient list dialog also lets you sort the merge output without re-sorting the Excel source spreadsheet itself.

When the preview looks correct for several recipients, click Finish & Merge. Three options appear: Edit Individual Documents creates a single Word document containing all merged pages — useful for review, manual edits, or saving an archive copy. Print Documents sends every merged page directly to the printer. Send Email Messages sends each merged document as an email through Outlook (only available if you chose Email Messages as the document type during setup).

The most cautious workflow is to choose Edit Individual Documents first, review the resulting document, fix anything that's still wrong, and then print or save from that combined output. This intermediate step catches issues you missed during preview because reviewing 200 pages in a single document is faster than clicking through 200 previews. It also gives you a permanent archive of exactly what was sent to whom that you can refer back to if a recipient questions the content later.

One additional best practice: save the Word template and the Excel data source in the same folder before merging. Word stores the data source path inside the template, and moving either file can break the connection. If the connection breaks, you'll get a prompt the next time you open the template asking you to relocate the data file. Saving them together (and opening the template only after both are in place) prevents most connection problems before they start. For recurring mail merges — a monthly invoice run, for example — this pattern saves hours over the course of a year.

Common formatting fixes — field switches

Word's mail merge field codes accept formatting switches that override how merged data appears. To see and edit the field code, click on a merge field in your Word template, press Alt+F9 to toggle field code view, and you'll see something like { MERGEFIELD Amount }. Add a switch inside the braces: { MERGEFIELD Amount \# "$#,##0.00" } formats the value as currency. Press Alt+F9 again to return to normal view. Right-click the field and choose Update Field to apply.

Date formatting uses the \@ switch: { MERGEFIELD EventDate \@ "MMMM d, yyyy" } produces "January 15, 2026". Other date pickformats: "M/d/yy" gives "1/15/26", "dddd, MMMM d, yyyy" gives "Thursday, January 15, 2026". The format codes match what Excel and Word use elsewhere, so once you learn one application's date format codes the other transfers easily.

For text that should always appear in upper or lower case, use \* Upper, \* Lower, or \* Caps for title case: { MERGEFIELD City \* Upper } produces "BOSTON" regardless of how the city is stored in Excel. The capitalization switches are useful for labels and envelopes where consistent case improves readability and matches USPS guidelines for outgoing mail processing.

Troubleshooting common mail merge issues

The most common issue is that merge fields appear as literal text ("<<FirstName>>") instead of being replaced. The cause is almost always that you typed the placeholder by hand instead of using Insert Merge Field. Word treats hand-typed text as plain text, not as a real field. Delete the placeholder, click Insert Merge Field, and select the column from the dropdown — Word inserts the proper field code that gets replaced during the merge.

The second-most-common issue is the data source connection breaking after the Excel file moves. Word stores the path to the data file inside the Word document. If you move the Excel file or rename it, the next time you open the Word template, you'll get a prompt asking you to locate the file. Browse to its new location and the connection rebuilds. To prevent the issue, save both files in the same folder and avoid moving either one once the merge is set up.

The third issue is recipients appearing in the wrong order. Mail merge processes rows top-to-bottom in the Excel source. To change the order, either re-sort the Excel file before opening the merge, or use the Edit Recipient List dialog in Word to sort by any column at merge time. The Word-side sort doesn't modify the Excel file, so it's reversible and safe to experiment with for one-time merges where you don't want to disturb the underlying spreadsheet.