Mail merge lets you create multiple personalized documents from a single template and a list of names and addresses

Mail merge in Word takes a template document — like a letter or label — and fills in different names, addresses, or other details for each person on your list. Instead of typing each letter individually, you write one version with placeholders, connect it to a spreadsheet or contact list, and Word generates a separate document for each row of data. The result is a stack of personalized letters, envelopes, or labels that look handwritten but took minutes to produce.

The process has three main parts: preparing your data in a list, setting up your template document with merge fields, and running the merge itself. Most people use a spreadsheet like Excel, but Word can also pull from Outlook contacts, Access databases, or a simple text file. The merge fields — the placeholders where names and addresses go — tell Word exactly where to insert each piece of information.

Key Takeaways

  • Mail merge requires two things: a template document with merge fields (the placeholders) and a data source like an Excel spreadsheet with columns for each piece of information you want to insert.
  • Your data source needs a header row with column names like "FirstName", "LastName", and "Address" — Word uses these names to match merge fields in your template.
  • You insert merge fields into your template by going to the Mailings tab, clicking Insert Merge Field, and selecting the column name from your data source.
  • The merge itself creates a new document with one copy of your template for each row in your data source, with all merge fields replaced by actual names and addresses.

Prepare your data in a spreadsheet before you start

Open Excel or Google Sheets and create a list with one column for each piece of information you want to merge. The first row must contain column headers — these are the names Word will recognize as merge fields. Common headers are FirstName, LastName, Address, City, State, ZipCode, and Email. Each row below the headers is one person who will receive a personalized document.

Make sure your data is clean before you start. Remove extra spaces at the beginning or end of names, use consistent capitalization, and check that every row has the same number of columns. If one person is missing a zip code, leave that cell blank rather than deleting it — an empty cell is fine, but a missing column breaks the merge. Save your spreadsheet as an Excel file (.xlsx) or CSV file (.csv) in a folder you can find easily.

Create your template document and connect it to your data

Open Word and write your template letter, envelope, or label exactly as you want it to appear. Type all the text that will be the same for everyone — the greeting, the body of the letter, the closing. Leave blank space where personalized information should go. For example, write "Dear [FirstName]," instead of "Dear John," so you can replace [FirstName] with the actual name later.

Once your template is ready, go to the Mailings tab at the top of Word. Click Start Mail Merge and choose the type of document you are creating — Letters, Envelopes, Labels, Email Messages, or Directory. Then click Select Recipients and choose Use an Existing List. Navigate to your Excel or CSV file and open it. Word will ask you to confirm which sheet contains your data and which row has your headers — usually the first row. Click OK, and Word now knows where to pull your names and addresses from.

Insert merge fields where personalized information goes

Click in your template document where you want the first name to appear. Go to the Mailings tab and click Insert Merge Field. A dropdown menu shows all the column headers from your spreadsheet. Click the one you want — for example, FirstName. Word inserts a merge field that looks like <<FirstName>> in your document.

Repeat this for every piece of information you want to personalize. If your letter says "Dear <> <>,", Word will replace those fields with the actual names from your spreadsheet. You can insert the same field multiple times — for example, <> might appear in the greeting and again in the closing. Type any text you want around the merge fields normally, like commas, spaces, or line breaks.

Preview your merge before you create all the documents

Before you run the full merge, check that everything looks right. In the Mailings tab, click Preview Results. Word shows you what the first document will look like with real data from your spreadsheet. Use the arrow buttons next to Preview Results to flip through a few examples and make sure the names, addresses, and formatting are correct. If something looks wrong — a merge field is missing, a name is in the wrong place, or the spacing is off — click Preview Results again to turn it off, fix your template, and then preview again.

Common problems at this stage are merge fields in the wrong order (like <> <> instead of <> <>), missing spaces between fields, or a field that did not insert correctly. If a field shows as <> instead of being replaced with data, right-click it and choose Update Field. If it still does not work, delete it and insert it again from the Mailings tab.

Run the merge to create your final documents

Once your preview looks correct, go to the Mailings tab and click Finish & Merge. You have three options: Edit Individual Documents, Print Documents, or Send Email Messages. Choose Edit Individual Documents if you want to review or make changes to each letter before printing or sending. Word creates a new document with all your merged letters, one after another, and you can scroll through, edit any that need it, and then print the whole batch.

Choose Print Documents if you want to print directly without reviewing each one. Word will ask which records to print — you can print all of them or just a range. Choose Send Email Messages if you are merging email addresses and want Word to send personalized emails through Outlook. After you click Finish & Merge, you are done — Word has created all your documents with real names and addresses in place of the merge fields.

Save your template for future use

After you finish a merge, save your template document so you can use it again with a different data source. Go to File > Save As and give it a clear name like "Annual Letter Template" or "Event Invitation Template". The merge fields stay in the document, so the next time you want to send personalized letters, you can open this template, connect it to a new spreadsheet with different names, and run the merge again.

You can also save the merged result — the document with all the personalized letters already created. This is useful if you want to keep a record of what you sent, or if you need to make small edits to individual letters before printing. Just save the merged document with a name that includes the date, like "Holiday Letters 2024", so you know which version you are looking at.

Frequently Asked Questions

What if my data is in Outlook contacts instead of Excel?

In the Mailings tab, click Select Recipients and choose Select from Outlook Contacts. Word opens your Outlook contact list and lets you choose which contacts to include in the merge. You can filter by category or search for specific people. The merge works the same way — Word uses the contact fields like FirstName, LastName, and Email as your merge fields.

Can I merge to email instead of printing letters?

Yes. Your data source must include an Email column with email addresses. In the Mailings tab, click Finish & Merge and choose Send Email Messages. Word opens a dialog where you select which column contains the email addresses and what you want the subject line to say. Word sends each email through Outlook with the personalized body text. This works best for short messages — long emails are easier to send as attachments.

What happens if I have blank cells in my data?

If a cell is empty, the merge field in that document will be blank too. For example, if one person has no middle name, the <> field will show nothing, leaving extra space. You can prevent this by using conditional merge fields that only show text if a field is not empty, but this requires more advanced setup. For simple merges, it is usually easier to just accept the blank space or manually edit those documents after the merge.

Can I merge labels or envelopes instead of letters?

Yes. When you click Start Mail Merge, choose Labels or Envelopes instead of Letters. For labels, Word asks which label size you are using — select your label brand and size from the list. For envelopes, set up your return address and then insert merge fields for the recipient address. The merge works the same way, creating one label or envelope for each row in your data source.