What a mail merge does and when you need it

A mail merge takes a list of names, addresses, or other information and plugs each one into the same letter or document template, creating personalized copies for each person on your list. Word pulls data from a separate file — usually an Excel spreadsheet or a CSV file — and inserts it into placeholders you set up in your document. The result is a stack of letters, emails, or labels that look individually written but were generated in minutes.

You use mail merge when you have the same message for many people but need each copy to include their specific details. Common examples are form letters to customers, personalized invitations, address labels for a mailing, or emails with each recipient's name in the greeting. Without mail merge, you would type each letter separately or copy and paste names one at a time — a process that gets tedious fast and invites mistakes.

Key Takeaways

  • Mail merge requires two files: a Word document with your template and placeholders, and a data file (usually Excel or CSV) with the names and information to insert.
  • You access mail merge through the Mailings tab in Word, and the process walks you through selecting your data source, inserting merge fields, and previewing the results.
  • Merge fields are the placeholders in your template — they look like <> and pull information from the columns in your data file.
  • You can preview how each merged document will look before you finish, so you can catch formatting problems or mismatched data before printing or sending.

Prepare your data file before opening Word

Your data file must be organized with one row of column headers at the top and one row of data for each person. If you are using Excel, put FirstName in column A, LastName in column B, Address in column C, and so on — whatever information your letter needs. Save the file and close it before you start the merge in Word. Word needs the file closed so it can read it without conflicts.

The column headers are critical: Word will look for them by name when you insert merge fields. If your Excel file has "First Name" but you try to insert a field called "FirstName", the merge will fail. Keep headers straightforward, one word if possible, with no spaces or special characters. Common headers are FirstName, LastName, Address, City, State, ZipCode, Email, and Company — whatever your letter template needs.

If your data is in a different format — a Google Sheet, a database, or a text file — export it as an Excel file or CSV (comma-separated values) first. Word can read both, but Excel is more reliable because it preserves formatting and column structure. A CSV file works too, but open it in Excel, check that the columns are correct, and save it as an Excel file before using it in Word.

Set up your letter template in Word

Open a new Word document and write your letter as you normally would. Include all the static text — the greeting, the body, the closing — exactly as it should appear in every copy. Where you want personalized information to go, leave a space or placeholder for now. For example, type "Dear [Name]," instead of "Dear John," so you remember where the merge field needs to go.

Format the letter the way you want it to look: set margins, choose your font, add your company logo or letterhead at the top. Everything you do to this template will appear in every merged document, so get the formatting right now. Save this file with a clear name like "MailMergeTemplate" or "CustomerLetter" — you will need to find it again when you start the merge process.

Insert merge fields into your template

Click the Mailings tab at the top of Word. In the ribbon, you will see a button called "Start Mail Merge" on the left. Click it and choose "Letters" from the dropdown menu. This tells Word you are merging into individual letters rather than labels or emails.

Next, click "Select Recipients" in the Mailings tab. Choose "Use an Existing List" and browse to your Excel or CSV file. Word will open a dialog showing the data in your file — check that the columns and data look correct, then click OK. Word now knows where your data is.

Go back to your template and click where you want the first piece of personalized information to appear. Delete the placeholder text you typed earlier. Click "Insert Merge Field" in the Mailings tab and select the column header that matches what you need — for example, "FirstName" for the recipient's first name. Word will insert a merge field that looks like <> in your document.

Repeat this for every piece of personalized information. If your letter says "Dear [Name], I wanted to reach out about your account at [Company]," you would insert <> after "Dear " and <> after "at ". Each merge field pulls from the matching column in your data file.

Preview and test your merge

Before you finish, click "Preview Results" in the Mailings tab. Word will show you what the first merged letter will look like, with real data from your file inserted into the merge fields. Use the arrow buttons to scroll through a few examples and check that the names, addresses, and other details are in the right places and formatted correctly.

Look for common problems: names that are cut off, addresses that run into the next line, or merge fields that did not insert properly. If a merge field shows <> instead of an actual name, it usually means the column header in your data file does not match the field name you inserted. Go back to your template, right-click the merge field, and check that it matches your Excel column headers exactly.

If the data looks wrong — for example, all the first names are in the wrong column — close the preview, click "Edit Recipient List" in the Mailings tab, and check your data file. You may need to go back to Excel, fix the column order or headers, save the file, and then update the recipient list in Word.

Complete the merge and save or print

Once the preview looks correct, click "Finish & Merge" in the Mailings tab. You have three options: "Edit Individual Documents" creates a new Word file with all the merged letters so you can review or edit them before printing; "Print Documents" sends them straight to your printer; or "Send Email Messages" if you are merging into emails instead of letters.

If you choose "Edit Individual Documents", Word creates a new file with all the merged copies. You can scroll through, make any last-minute changes, and then print or save as needed. This is the safest option if you want to double-check everything before it goes out.

If you choose "Print Documents", Word will print one copy of each merged letter directly to your printer. Make sure your printer is on and loaded with paper. If you choose "Send Email Messages", Word will open a dialog asking which column contains email addresses and what subject line to use.

Save your template for future use

After you finish the merge, save your template document. The next time you need to send the same letter to a different group of people, you can open this template, update the recipient list to point to a new data file, and run the merge again. You do not have to rebuild the template from scratch.

Keep your data files organized too. If you merge to the same group of people regularly — like monthly customer letters — save each month's data file with the date in the name, like "CustomerList_January2024.xlsx". This way you have a record of who received what and when, and you can reuse the template without confusion.

Frequently Asked Questions

What if my data file has extra columns I do not need in the letter?

Extra columns do not matter. Word only inserts the merge fields you actually put in your template. If your Excel file has FirstName, LastName, Address, Phone, and Email, but your letter only uses FirstName and Address, the Phone and Email columns are ignored. You can keep them in the file for your own records.

Can I merge to email instead of printing letters?

Yes. Set up your template as an email body instead of a letter, insert merge fields for the recipient's name and any other details, then choose "Send Email Messages" when you finish the merge. Your data file must have a column with email addresses. Word will send one email to each address with the personalized content.

What if I make a mistake in the template after I start the merge?

Close the merge without finishing, edit your template, and start over. If you have already created the merged documents in a new file, you can edit them there too, but it is faster to fix the template and re-merge. The template is the source, so changes there will explore to all future merges.

Can I merge into labels or envelopes instead of full letters?

Yes. When you click "Start Mail Merge", choose "Labels" or "Envelopes" instead of "Letters". Word will guide you through setting up the label or envelope format, and the merge process is the same — you still insert merge fields for names and addresses, preview, and finish.

How do I merge only some of the people in my data file, not all of them?

Click "Edit Recipient List" in the Mailings tab before you finish the merge. You can uncheck the box next to any person's name to exclude them from the merge. This is useful if your data file has 100 people but you only want to send letters to 50 of them this time.