Word Mail Merge Guide — Create Hundreds of Personalized Documents from an Excel List

Need to send the same letter to 100 people — with only the name changing each time? Word Mail Merge connects a single Word template to an Excel list and produces hundreds of personalized documents in one go. Invitations, notices, contract cover pages, address labels, envelopes — handle all of it without copying and pasting a single name.

What Is Mail Merge — and When Should You Use It?

Mail Merge fills a Word template with data from an Excel spreadsheet, generating one output document per row. Originally designed for mass mailings, it is now used for a wide range of office tasks.

• Invitations & notices — insert each guest's name and affiliation into 100 invitations at once
• Contracts & appointment letters — same form, different name/date/title per person
• Shipping & mailing labels — print recipient addresses on label sheets in bulk
• Envelopes — auto-position name and address on each envelope
• Directories — compile a formatted contact list directly from your data

If you need to produce 10 or more documents that differ only in a few fields, Mail Merge is the fastest way to do it.

Step 1 — Prepare Your Excel List

A clean spreadsheet is the foundation of a smooth merge. Follow these rules:

• Row 1 = field names — put column headers like Name, Address, Company, Email in the very first row. These become the merge field names in Word.
• Row 2 onward = data — one person (or one record) per row.
• No blank rows or columns — a blank row in the middle will cut off your list at that point.
• Watch number formatting — postal codes or phone numbers that start with 0 should be formatted as Text, or the leading zero will be stripped.

Save the file as .xlsx and note which sheet holds your data (the default "Sheet1" is fine).

Step 2 — Run the Merge in Word

Open your Word template and follow these steps:

1. Click the Mailings tab — select the Mailings tab in the ribbon at the top.
2. Start Mail Merge — click "Start Mail Merge" and choose a document type:
   • Letters — standard A4/letter-size document (most common)
   • Envelopes — Word sets up the envelope size and orientation automatically
   • Labels — choose a label brand and product number
   • Directory — compiles all records into a single formatted list
3. Select Recipients — click "Select Recipients" → Use an Existing List, then browse to your Excel file. When prompted, choose the sheet that contains your data.
4. Insert Merge Fields — place the cursor where a name or address should appear, then click Insert Merge Field. A dropdown lists every column header from your spreadsheet. Select one and Word inserts a placeholder like «Name». Repeat for each field you need.
5. Preview Results — click "Preview Results" to see real data substituted for the placeholders. Use the arrow buttons to page through records and check for errors.
6. Finish & Merge — when everything looks right, click Finish & Merge and choose:
   • Edit Individual Documents — all records in one Word file, one page each, ready for last-minute tweaks
   • Print Documents — send directly to the printer
   • Send Email Messages — deliver via Outlook, using an email column as the recipient address

Labels & Envelopes — Multiple Records per Page

Labels and envelopes follow the same workflow, with one extra setup step at the beginning.

• Labels — after choosing Labels in the Start Mail Merge menu, select the label manufacturer (Avery, etc.) and the product number. Word builds a table that matches your label sheet. Insert fields into the first cell only, then click Update Labels to copy the layout to every other cell on the sheet.
• Envelopes — choose your envelope size, and Word positions the return address and delivery address zones automatically. Insert merge fields into the delivery address zone.

Check the product number printed on your label packaging and match it in Word's list. If your brand is not listed, you can set the number of columns, rows, and cell dimensions manually to match the sheet.

Final Step — PDF or E-Signature

Once the merge is done, share or archive the result as a PDF. Use Word's "Save As → PDF" option, or an online converter to avoid font issues and keep file sizes small.

If the documents need signatures — contracts, consent forms, acknowledgment letters — upload the PDF to FreeSign and send individual e-signature requests with one click. Each signer receives a personal link, and the signed file is saved automatically.

Useful Tools

Convert your merged Word file to PDF with FreeSign Word → PDF — no installation, no account, free. Font rendering is handled server-side so characters never break. For e-signatures on the finished PDF, FreeSign lets you send individual signing requests straight from your browser.

Frequently Asked Questions

Q. I connected my Excel file but the field list is empty.
The most common cause is that Row 1 of your spreadsheet has no headers, or the file was open in Excel when you linked it. Close the Excel file and try reconnecting. Sheet names containing special characters can also trigger this error.

Q. There are blank pages between each merged letter.
An extra paragraph mark at the end of the template is usually the culprit. Turn on "Show Formatting Marks" in Word and delete any empty paragraphs after the last merge field.

Q. Can I merge for only some of the people on my list?
Yes. Open "Edit Recipient List" and use the checkboxes to include or exclude individual records, or apply a filter condition (for example, City = Seoul) to target a subset automatically.

Q. Fonts look broken after I convert to PDF.
Try saving as PDF directly from Word (File → Save As → PDF). If the problem persists, use FreeSign Word → PDF — the conversion runs server-side and embeds fonts so nothing breaks.