What mail merge does and why you'd use it

Mail merge is a Word feature that takes a list of names, addresses, or other information from a spreadsheet and automatically fills them into a template letter or document. Instead of typing the same letter fifty times with different names, you create one template, point Word to your list, and it produces fifty personalized copies in seconds.

The most common use is sending personalized letters — a school mailing report cards to parents, a business sending invoices to customers, or a nonprofit thanking donors by name. But mail merge also works for envelopes, labels, and email messages. The data comes from anywhere: an Excel spreadsheet, a CSV file exported from a database, or even a Word table you build yourself.

The trade-off is setup time. The first time you do this, it takes longer than just writing one letter. But if you're sending the same message to ten or more people, mail merge saves time and cuts the chance you'll accidentally send the wrong version to the wrong person.

Key Takeaways

  • Mail merge requires two files: a Word template with placeholders for names and addresses, and a spreadsheet or CSV file with the actual data.
  • You start the merge in Word under the Mailings tab, then connect to your data source and insert merge fields where you want information to appear.
  • Word shows you a preview of what each merged document will look like before you finish, so you can catch mistakes.
  • The final output is a single Word document with all the personalized copies, which you can then print or save as separate files.

Prepare your data in a spreadsheet first

Before you open Word, create or gather your data in Excel, Google Sheets, or save it as a CSV file. The first row must be column headers — the names Word will recognize. For example: FirstName, LastName, Address, City, State, ZIP, Email. Make sure there are no blank rows in the middle of your data, and check that names and addresses are spelled correctly, because Word will copy them exactly as they appear.

If your data is in Google Sheets, read it as an Excel file (.xlsx) or CSV (.csv) before you start the merge. Word can sometimes read Google Sheets directly, but saving a local copy prevents connection problems mid-merge. If you're merging email addresses, put them in their own column with a clear header like "EmailAddress".

Create your template letter in Word

Open a new Word document and write the letter or document you want to send. Type it exactly as you want it to appear, including your signature block, letterhead, or any standard text. Wherever you need a name, address, or other information to change from one copy to the next, leave a blank space or type a placeholder like [FirstName] or [Address] — you'll replace these with actual merge fields in the next step.

For example, a thank-you letter might look like this:

Dear [FirstName],Thank you for your donation of [DonationAmount]. Your support helps us continue our work.Sincerely,Jane SmithExecutive Director

Save this template with a clear name like "DonorThankyou_Template" before you move to the merge step. You'll need to save it again after you insert merge fields, so having a descriptive name helps you keep track of versions.

Connect Word to your data and insert merge fields

Click the Mailings tab at the top of Word. Click Start Mail Merge, then choose the type of document you're creating — Letters, Email Messages, Envelopes, Labels, or Directory. For a standard letter, choose Letters.

Next, click Select Recipients. Choose Use an Existing List, then browse to your Excel or CSV file and open it. Word will ask which sheet to use if your file has multiple sheets — pick the one with your data. A dialog box will appear showing your column headers; click OK to confirm.

Now go back to your template and click where you want the first piece of data to appear. Click Insert Merge Field and select the column header that matches — for example, FirstName. Word inserts it as <<FirstName>> in your document. Repeat for every field you need: LastName, Address, City, and so on. The merge field stays in angle brackets; that's normal and won't print.

Preview and test before you finish

Click Preview Results in the Mailings tab. Word shows you what the first merged document will look like with real data from your spreadsheet. Use the arrow buttons to scroll through a few examples and check that names, addresses, and other information are in the right places and formatted correctly.

Look for common problems: a missing space between first and last name, an address that wraps awkwardly, or a merge field that didn't insert. If you spot an error in the data itself (a misspelled name or wrong address), close the preview, go back to your spreadsheet, fix it, and save. Then click Preview Results again to see the correction.

If the template itself needs fixing — for example, you want to add a space or change the wording — close the preview, make the change, and preview again. Do not proceed to the final merge until the preview looks right.

Complete the merge and save your output

Click Finish & Merge in the Mailings tab. You have three options: Edit Individual Documents creates one Word file with all the merged letters, one after another. Print Documents sends them straight to your printer. Send Email Messages uses the email addresses in your data to send the letters as email bodies (not attachments).

For most situations, choose Edit Individual Documents. Word creates a new document called "Letters1" (or similar) containing all your personalized copies. You can then review the whole thing, print it, save it, or edit individual letters if needed. If you want to save each letter as a separate file, you'll need to manually split the document or use a macro — Word doesn't do this automatically in the standard merge.

Save the merged output with a name that includes the date, like "DonorThankyou_2025Jan15", so you have a record of what you sent and when.

Troubleshooting common problems

Word can't find your data file. Make sure the file is saved in a location you can access (not a cloud folder that's still syncing), and that it's in Excel or CSV format. If you're using a CSV file, open it in Excel first to confirm it looks right — sometimes CSV files display oddly depending on your regional settings.

Merge fields show as <<FieldName>> instead of actual data. This usually means the preview is off. Click Preview Results to turn it on and see real data. If you print or finish the merge without preview on, you'll get the field names instead of the data.

Some records are missing or in the wrong order. Check your spreadsheet for blank rows or hidden rows. Word skips blank rows, and hidden rows may not merge. Also confirm you selected the right sheet if your file has multiple sheets.

Email merge isn't working. Make sure your email addresses are in a column with a clear header like "Email" or "EmailAddress". Word's email merge also requires Outlook to be installed and configured on your computer — it won't work with Gmail or other web-based email alone.

Frequently Asked Questions

Can I merge to PDF instead of Word?

Not directly from the Mailings tab. After you finish the merge and have all your letters in one Word document, you can save that document as a PDF. If you need each letter as a separate PDF file, you'll have to split the merged document first, then convert each one individually.

What if I only want to merge to some of the people on my list?

After you select your data source, click Edit Recipient List in the Mailings tab. Uncheck the names you don't want to include. Only the checked rows will merge into your final document.

Can I use mail merge with a Google Sheet without downloading it?

Word can sometimes connect to Google Sheets directly, but the connection is unreliable and may fail mid-merge. Downloading as an Excel file first is safer and faster. If you need to update the data later, read a fresh copy and redo the merge.

How do I add an if-then condition, like "Dear Mr. Smith" or "Dear Ms. Smith" based on gender?

This requires an IF merge field, which is more advanced. In the Mailings tab, click Rules and choose If...Then...Else. You'll need a column in your data that specifies the title (Mr., Ms., Dr.), or you can use the IF field to check another column and insert the right title automatically. This takes practice; Word's help documentation covers the syntax.

What happens if I edit the template after I've already merged once?

The merged document you created won't change — it's a separate file. If you edit the template and want to merge again with the same data, open the template, redo the merge steps, and you'll get a new output file. Keep the template saved so you can reuse it.