Prepare your Excel spreadsheet for mail merge

Most mail merge problems start in the spreadsheet. Before connecting Excel to Word, make sure the list is clean and easy for Word to read.

• Use clear column headers. For a greeting, use separate columns such as First Name and Last Name.
• Keep one recipient, customer, student, or order in each row. Mail merge works best when each row is one final document or message.
• Format ZIP codes, dates, currencies, and ID numbers in Excel first. Word reads values from the spreadsheet, so inconsistent formats can show up in the merged output.
• Avoid blank headers, duplicate column names, and merged cells. These are common causes of missing fields or invalid merge field errors.
• Finish spreadsheet edits before connecting it. If you rename headers later, Word may show missing or invalid merge fields.

If your source data is still in a Word table instead of Excel, move it into a spreadsheet first. This makes field matching easier before you start the merge; see how to convert Word to Excel if you need the reverse setup.

Connect and edit the mailing list

Connect the Word document to your Excel data source, then review the recipient list before you add fields to the template.

1. Open the Word document you want to use as the mail merge template.
2. Go to Mailings.
3. Choose Select Recipients or Use an Existing List, then select your Excel spreadsheet.
4. If prompted, choose the worksheet that contains your data list.
5. Choose Edit Recipient List to remove records, sort names, or filter the list.
6. Clear the check box next to any person or record that should not be included.

Insert merge fields into the Word template

If your goal is only to place an Excel table or chart inside a Word report, that is a different workflow from mail merge. Use how to insert Excel into Word instead.

Merge fields pull information from the Excel spreadsheet into your Word template. You can insert a full address block, a greeting line, or individual fields such as invoice number, due date, first name, last name, email, city, state, or ZIP code.

1. Click where the merged information should appear in the Word document.
2. Go to Mailings > Address Block if you are creating letters, envelopes, or address labels.
3. Choose Greeting Line if you want Word to add a greeting such as “Dear Anna”.
4. Choose Insert Merge Field for custom fields such as invoice number, payment amount, certificate name, event date, or account ID.
5. Repeat until all personalized areas in the template have the right fields.
6. Choose File > Save to save the connected template.

Example: letter mail merge

Use mail merge for labels, envelopes, and email messages

Mail merge is not limited to letters. The same Excel-to-Word workflow can create address labels, envelopes, personalized notices, certificates, invoices, and in some setups, email messages.

Fix dates, currency, number formats, ZIP codes, and field mismatches

Users often search for mail merge fixes after the fields already appear in the document. Check these common cases before you finish the merge.

ZIP codes lose leading zeros

If a ZIP code such as 00501 appears as 501 after the merge, the ZIP code column is probably stored as a number in Excel. Format the ZIP Code or Postal Code column as Text before connecting it to Word. If you already connected the spreadsheet, save the corrected Excel file, reopen the Word merge document, and reconnect the data source.

Dates and currency look wrong

If dates or amounts do not look right after the merge, first check the Excel source column. Use one consistent date style and currency format before connecting the spreadsheet. For example, do not mix 03/15/2026, March 15, 2026, and 15 March 2026 in the same column. Preview several records before finishing, especially if the document includes payment amounts or due dates.

Numbers lose commas or decimal places

If values such as 1,250.00 appear as 1250, or if amounts show too many decimal places, check the number format before finishing the merge. Use a consistent number, currency, or accounting format in Excel, then preview several records in Word. For advanced cases, you may need to update the Word MERGEFIELD code with a numeric format switch, but most basic thousand separator and decimal place issues should be fixed in the Excel source first.

Invalid merge field or missing field

If Word shows an invalid merge field, the Excel header may have changed after the spreadsheet was connected. Check the first row of the Excel file and make sure the column names still match the fields in the Word template. Avoid duplicate headers, blank headers, or renamed columns. If needed, reconnect the Excel data source and insert the fields again.

Blank fields appear in the merged document

Blank fields usually mean the source cell is empty, the wrong worksheet was selected, or the template is using a field that no longer exists. Check the recipient row in Excel, confirm the worksheet name, and compare each Word field with the header row before finishing the merge.

Preview and finish the mail merge

After you insert the fields, preview the results to confirm that the merged content is correct.

1. Go to Mailings > Preview Results.
2. Choose Next or Previous to move through records in your data source.
3. Check names, addresses, dates, ZIP codes, and any fields that may be blank.
4. Go to Finish & Merge.
5. Choose an output option, such as Edit Individual Documents, Print Documents, or Send E-mail Messages.

Save and reuse your mail merge document

If you need this process to run regularly for reports, invoices, certificates, or other recurring documents, compare Excel to Word document automation options before building a manual workflow.

When you save the mail merge document, it can stay connected to the Excel data source. This lets you reuse the template for the next bulk mailing, invoice batch, label set, or certificate run.

• Keep the original template separate from the finished merged output.
• Keep the Excel source file in a stable folder if you plan to reuse the merge.
• When Word prompts you to keep the connection, choose the option that fits your workflow.

Use WPS Office for Word and Excel files

If you are using WPS Office, prepare the data list in WPS Spreadsheet and edit the template in WPS Writer. For WPS-specific menu steps, follow the mail merge from Excel to Word guide in WPS Office.

If you only need to turn a spreadsheet into a Word document instead of filling a template with Excel rows, use an Excel to Word converter online.

FAQs About Mail Merge from Excel to Word