Mail Merge with Word & Excel

Benjamin Franklin was, among many other things, a printer and publisher. He knew better than anyone that a message lands harder when it speaks directly to its reader. Imagine if Franklin were publishing his Pennsylvania Gazette in 2026 — he would not write 2,000 identical letters to his subscribers. He would use Mail Merge to address each reader by name, reference their colony, and tailor the salutation so every copy felt personal. And notice how neatly this ties back to atomic fields: a clean, structured subscriber list — like the one Thomas Paine could have built for his own pamphlet subscribers — is exactly the kind of Excel data source that makes a Mail Merge work flawlessly.

Word's Mail Merge feature lets you write the letter or document once — with placeholder fields like <> and <> — and then connect it to an Excel spreadsheet containing your recipient data. Word merges them together and produces a fully personalized copy for every row in your spreadsheet. Whether you are sending invoices, membership renewals, appointment reminders, or personalized marketing letters, this is one of the biggest time-saving features in all of Microsoft Office.

Step 1: Prepare your Excel data file

1. Open a new or existing Excel workbook and set up your data with clear column headers in Row 1 — for example: FirstName, LastName, Colony, City, StreetAddress.
2. Enter one record per row beneath the headers. Every column header becomes a merge field you can insert into your Word document.
3. Remove any blank rows or merged cells in the spreadsheet — they can cause merge errors. Save and close the file.

Step 2: Set up your Word document and connect the data

1. Open Word and create your letter template. Write the content as you normally would, but leave placeholder spaces wherever personalized information should appear.
2. Go to the Mailings tab on the ribbon and click Start Mail Merge, then choose Letters (or the document type that fits your need).
3. Click Select Recipients → Use an Existing List and browse to your Excel file. Select the correct worksheet when prompted and click OK.

Step 3: Insert merge fields and complete the merge

1. Click in your document at the spot where you want personalized data to appear — for example, the salutation line.
2. On the Mailings tab, click Insert Merge Field and choose the column header you want — such as FirstName. It will appear as <> in your document. Repeat for each field you need.
3. When all fields are placed, click Preview Results on the Mailings tab to see what the real data looks like in place of the field codes. Page through a few records to verify everything looks correct.
4. When you are satisfied, click Finish & Merge → Edit Individual Documents to create one combined file with all personalized copies, or choose Print Documents to send them straight to the printer.

The takeaway

Mail Merge is one of those features that pays for itself the very first time you use it. If your office regularly sends out bulk correspondence that should feel personal, this is the tool that makes it possible — the same principle Franklin understood at his printing press, just without the ink-stained hands.