What a mail merge does and why you need it

A mail merge takes a list of names, email addresses, or other details from a spreadsheet and plugs each one into a template letter or email in Word. Instead of typing the same message fifty times with different names, you write it once, connect it to your data, and Word creates fifty personalized versions automatically. Each one pulls the recipient's actual name, company, or any other field you've stored.

The process has three parts: a Word document with your template text, a data source (usually an Excel spreadsheet) holding the names and details, and the merge itself that combines them. Once you've set it up once, you can reuse the same template and data source for future sends.

Key Takeaways

  • Your data source must be an Excel spreadsheet with column headers in the first row — one column for first names, one for email addresses, one for company names, and so on.
  • In Word, you insert merge fields (like <<FirstName>>) into your template where you want personalized information to appear.
  • The Mailings tab in Word contains all the merge tools — you start by selecting your data source, then preview and complete the merge.
  • Word creates a new document with all merged letters or emails, which you then send manually or copy into your email program.
  • Test your merge with one or two rows of data before running it on your full list to catch formatting or spelling mistakes.

Prepare your data in Excel before opening Word

Your data source must be an Excel spreadsheet. Open Excel and create a new sheet. In the first row, type the column headers exactly as you want to use them: FirstName, LastName, Email, Company, or whatever fields you need. Do not leave the first row blank — Word uses row one to identify which columns exist.

Starting in row two, enter your actual data. One person per row. If you have 50 names, you'll have 50 rows of data below the header row. Make sure there are no blank rows in the middle of your list — if row 15 is empty, Word may stop merging at row 14. Save this file with a clear name like "MailMergeList.xlsx" and close it. You do not need to keep Excel open while you work in Word.

Check your data for typos and inconsistencies before you start the merge. If a name is spelled wrong in the spreadsheet, it will be spelled wrong in all 50 merged documents. The same applies to email addresses — if you type "jsmith@gmial.com" instead of "jsmith@gmail.com", that mistake will copy to every merged version.

Open Word and start the merge from the Mailings tab

Create a new blank document in Word or open an existing template. Click the Mailings tab at the top of the ribbon. On the far left, you'll see a button labeled Start Mail Merge. Click it and select Letters (even if you're creating emails — Word treats them the same way for merge purposes).

Next, click Select Recipients, also in the Mailings tab. A dropdown menu appears. Choose Use an Existing List. A file browser opens. Navigate to your Excel spreadsheet and click it once to select it, then click Open. A dialog box appears asking which sheet you want to use — if you only have one sheet, it's already selected. Click OK.

Word now knows where your data lives. You won't see the data on screen yet — that comes next. The spreadsheet stays closed; Word reads it in the background.

Insert merge fields where names and details should appear

Click in your Word document where you want the first personalized detail to appear. For example, if you're writing "Dear John," click right after "Dear " and before the comma. Click the Insert Merge Field button in the Mailings tab. A dropdown list appears showing all the column headers from your Excel sheet — FirstName, LastName, Email, Company, and so on.

Click FirstName. Word inserts the text <<FirstName>> into your document. This is a merge field. When you run the merge, Word will replace <<FirstName>> with the actual first name from each row of your spreadsheet. Continue writing your template. If you need the last name later in the letter, click where you want it and insert the <<LastName>> field the same way.

You can insert the same field multiple times. If your letter says "Dear <<FirstName>>," and later says "Thank you, <<FirstName>>," that's fine — both instances will pull from the FirstName column. Do not type the merge field by hand. Always use the Insert Merge Field button, because Word needs to recognize it as a field, not just text.

Preview your merge before you run it

Before you create all the merged documents, preview a few to make sure everything looks right. In the Mailings tab, click Preview Results. Your template now shows real data from your spreadsheet instead of the merge field names. You'll see the first person's information. Click the arrow buttons next to Preview Results to scroll through a few examples — check that names appear correctly, that spacing looks right, and that you haven't missed any fields.

If something is wrong — a name is misspelled, or a merge field is in the wrong place — click Preview Results again to turn it off, make your edits to the template, and preview again. Do this before you run the full merge. Once you've created 50 documents, fixing a typo means redoing the whole thing.

Pay special attention to spacing. If your template says "Dear <<FirstName>>," and FirstName is blank for some reason, you'll end up with "Dear ," which looks wrong. Add a space or adjust punctuation if needed.

Complete the merge and save the results

Once your preview looks correct, click Finish & Merge in the Mailings tab. A dropdown menu appears with three options: Edit Individual Documents, Print Documents, or Send Email Messages. For most people sending emails, choose Edit Individual Documents. Word creates a new document containing all your merged letters, one after another, each with the correct personalized information.

A dialog box asks which records you want to merge — all of them, or a specific range. Choose All unless you only want to merge a few rows. Click OK. Word creates the merged document and opens it. This new document is separate from your template. Your original template remains unchanged and ready to use again.

Save this merged document with a clear name like "MergedLetters_January.docx". You now have one document with all 50 personalized letters. You can print them, email them individually, or copy and paste them into your email program one at a time. If you chose Send Email Messages instead, Word would try to send them directly through Outlook, but that route often requires extra setup — editing individual documents gives you more control.

Copy merged emails into your email program

If you're sending these as emails rather than printed letters, you'll need to move them into your email program. The simplest method is to copy and paste. Select all the text in the first merged letter (or select just the body if you want to add your own subject line), copy it, and paste it into a new email in Gmail, Outlook, or whatever program you use. Type the recipient's email address in the To field.

For large batches, this becomes tedious. Some people export the merged document to PDF, one file per person, and attach those. Others use the Send Email Messages option during the merge if they're comfortable with Outlook integration. The trade-off is control versus speed — manual copying takes longer but gives you a chance to review each email before it goes out.

Frequently Asked Questions

What if my Excel file has blank cells?

Word will leave that field blank in the merged document. If you're merging "Dear <<FirstName>>," and a row has no first name, you'll get "Dear ," which looks broken. Clean your data before merging — fill in missing names or remove incomplete rows. If some people don't have a middle name, that's fine; just leave that column blank for them.

Can I merge into emails instead of letters?

Word's mail merge creates documents, not emails. You can write an email-style letter in Word and merge it, then copy the results into your email program. If you want Word to send emails directly through Outlook, use the Send Email Messages option during Finish & Merge, but this requires Outlook to be set up on your computer and can be finicky.

How do I reuse the same template for a different group of people?

Your template document stays unchanged after a merge. Open it again, click Select Recipients in the Mailings tab, and choose a different Excel file. Word will merge the same template with the new data. You can also keep multiple templates for different types of letters and reuse each one with different data sources.

What if I only want to merge some rows, not all 50?

During the Finish & Merge step, a dialog box asks which records to include. You can choose a specific range — for example, rows 1 through 10. This is useful for testing or for sending to a subset of your list.

Can I merge images or other content besides text?

Mail merge in Word works primarily with text fields. You can insert images or logos in your template, but they'll be the same in every merged document. You cannot pull different images from your spreadsheet for each person.