What mail merge does and when to use it

Mail merge is a feature that takes a list of names, addresses, or other information and automatically fills them into a template letter or email. Instead of typing the same message fifty times with different names, you write it once and let the software insert each person's details where you mark them.

You use mail merge when you need to send personalized messages to many people at once — a landlord notifying tenants of a rent increase, a school sending acceptance letters, a nonprofit thanking donors by name. The software pulls information from a spreadsheet or database and plugs it into your document in seconds.

Mail merge works in Microsoft Word (for letters and documents you print or email as attachments) and in Gmail (for emails sent directly from your inbox). Google Docs does not have a built-in mail merge feature, but you can use a free add-on called Mail Merge for Gmail to do the same thing.

Key Takeaways

  • Mail merge requires two files: a template with placeholders where names or details go, and a spreadsheet with the actual data for each person.
  • In Word, you create the template, connect it to your data source, and insert merge fields where information should appear.
  • In Gmail, you upload a spreadsheet and use Mail Merge for Gmail to send personalized emails without typing each one separately.
  • The most common mistake is forgetting to save your data file before starting the merge, which causes Word to lose the connection.
  • Always do a test merge with one or two rows first to catch typos or formatting problems before sending to everyone.

Setting up your data file in a spreadsheet

Before you open Word or Gmail, create a spreadsheet with the information you want to merge. Open Excel, Google Sheets, or any spreadsheet program. Put the category names in the first row — for example, "First Name", "Last Name", "Address", "Rent Amount". Each column is one piece of information.

Type each person's details in the rows below. One row per person. Make sure the spelling is correct and consistent — if one row says "John" and another says "Jon", the merge will use exactly what you typed. Save this file with a clear name like "Tenant_List.xlsx" or "Donor_Data.csv" and remember where you saved it. You will need to find it again when you set up the merge.

Do not leave blank cells in the middle of your data. If someone does not have a middle name, leave that cell empty, but do not skip rows. Mail merge reads from top to bottom and stops when it hits a blank row.

Creating a mail merge in Microsoft Word

Open Word and write your template letter or document. Type the message exactly as you want it to appear, but leave blank spaces where the personalized information should go. For example: "Dear [FIRST NAME], your rent of [RENT AMOUNT] is due on the 1st of each month."

Once your template is written, go to the Mailings tab at the top of the Word window. Click Start Mail Merge and choose the type of document you are creating — usually Letters if you are printing or emailing as an attachment, or Email Messages if you are sending directly from Word (though Gmail is usually easier for email).

Next, click Select Recipients and choose Use an Existing List. Navigate to the spreadsheet file you created and open it. Word will ask which sheet contains your data — select the right one and click OK. Word now knows where your data is.

Go back to your template and click where you want the first piece of information to appear. Click Insert Merge Field and select the column name from your spreadsheet — for example, "First Name". Word inserts a placeholder that looks like <<First Name>>. Repeat this for every piece of information you want to merge. When you are done, your template might look like: "Dear <<First Name>> <<Last Name>>, your rent of <<Rent Amount>> is due on the 1st."

Previewing and completing the merge in Word

Before you merge to all recipients, preview what the letters will actually look like. Click Preview Results in the Mailings tab. Word shows you the first letter with real names and data filled in. Use the arrow buttons to scroll through a few letters and make sure everything looks right — names are spelled correctly, amounts are in the right place, and no merge fields are left blank.

If something is wrong, click Preview Results again to turn off the preview, fix your template, and then turn the preview back on. Do not skip this step. A typo in your template will appear in every single letter.

When the preview looks correct, click Finish & Merge. You have three options: Edit Individual Documents (creates one document with all merged letters so you can review or edit before sending), Print Documents (sends directly to your printer), or Send Email Messages (if your data includes an email column). Choose the option that matches what you need to do.

Setting up mail merge in Gmail with an add-on

Gmail does not have mail merge built in, but the free add-on Mail Merge for Gmail does the job. First, open Gmail in your web browser. Click the Google Apps menu (the grid of nine dots in the top right) and select Gmail to make sure you are in Gmail, not another Google product.

Click the three-line menu icon on the left side and scroll down to Settings. Go to the Advanced tab and make sure Templates is enabled. Close settings and go back to your inbox.

Click the three-line menu again and look for Mail Merge for Gmail in the list. If you do not see it, click Get Add-ons, search for "Mail Merge for Gmail", and click the blue Install button. You may need to give the add-on permission to access your Gmail account.

Writing and sending merged emails in Gmail

Compose a new email in Gmail. Write your message with placeholders where you want personalized information — for example, "Hi [First Name], thank you for your donation of [Amount]." Do not use the << >> brackets like Word does; just put the column name in square brackets.

When your email is written, click the three-line menu and select Mail Merge for Gmail. A sidebar opens on the right. Click get your free guide and upload your spreadsheet file. Select which sheet contains your data and which column contains the email addresses where the merged emails should go.

The add-on shows you a preview of the first email with real data filled in. Check that names and amounts are correct. If everything looks right, click Send. The add-on sends one personalized email to each person in your list. You can watch the progress in the sidebar as it sends.

Troubleshooting common mail merge problems

If Word says "No data source" or "Cannot find the file", the spreadsheet moved or you saved it in a different location after starting the merge. Save your spreadsheet in a permanent folder before you begin. If the merge already started, click Select Recipients again and navigate to the file in its new location.

If merge fields show as <<First Name>> instead of actual names in your final document, you did not complete the merge. Go back to the Mailings tab and click Finish & Merge to create the actual merged documents.

If some emails in Gmail do not send, check that the email address column in your spreadsheet has no typos and no blank cells. Mail Merge for Gmail skips rows with missing email addresses. If a column name in your template does not match exactly what you named it in the spreadsheet — for example, "firstname" instead of "First Name" — the merge will not recognize it and will leave it blank.

If your merged letters have extra spaces or odd line breaks, you probably have spaces inside your merge field placeholders. Delete the field and insert it again, making sure there are no spaces before or after the field name.

Frequently Asked Questions

Can I merge to only some people in my list, not everyone?

In Word, yes. Before you finish the merge, click Finish & Merge and choose Edit Individual Documents. Word creates a new document with all merged letters. Delete the ones you do not want and save the document. In Gmail, Mail Merge for Gmail sends to everyone in your spreadsheet, so create a separate spreadsheet with only the people you want to reach.

What if my spreadsheet has a column I do not want to merge?

You do not have to use every column. In Word, straightforward do not insert a merge field for that column. In Gmail, the add-on only inserts the columns you reference in your email template. Extra columns in the spreadsheet are ignored.

Can I merge images or attachments?

Word can merge images if they are stored as file paths in your spreadsheet, but it is complicated. For most people, it is easier to add the same image to every letter manually or use a template with the image already in place. Gmail cannot merge attachments at all — you would need to send them separately or use a different tool.

How do I merge dates or numbers with specific formatting?

In your spreadsheet, format the cells the way you want them to appear — dates as "January 15, 2024" instead of "1/15/24", numbers with dollar signs like "$1,500". When you merge, Word and Gmail will use the formatting from your spreadsheet.

What happens if I edit my spreadsheet after I start the merge in Word?

Word reads the data when you first select the file. If you edit the spreadsheet after that, Word does not automatically update. Close the merge, save and close the spreadsheet, then start the merge again and select the file once more.