What Mail Merge Does and Why You'd Use It

Mail merge takes a list of names, email addresses, and other details from a spreadsheet and automatically fills them into an email template, so you send one message to many people with each one personalized to the recipient. Instead of typing "Dear Sarah" in one email and "Dear Marcus" in another, you write the template once with a placeholder like [FirstName], and the mail merge tool replaces it with the actual name for each person.

This is useful when you're sending the same message to a group but want each recipient to see their own information — a job offer with their specific salary, a class roster with each student's section number, a renewal notice with each customer's account details. Without mail merge, you'd either send a generic message to everyone or spend hours copying and pasting.

Mail merge works in Microsoft Outlook, Gmail, Google Workspace, and several third-party tools. The basic steps are the same across all of them: prepare a spreadsheet with your recipient data, create an email template with placeholders, connect the two, and send.

Key Takeaways

  • Mail merge pulls names and details from a spreadsheet and inserts them into an email template so each recipient sees a personalized message.
  • Your spreadsheet must have one column per data type (FirstName, LastName, Email, etc.) with headers in the first row and no blank rows between entries.
  • In your email template, you mark where data goes by typing placeholders in double brackets, like [FirstName] or [CompanyName].
  • Outlook's mail merge is built into the program; Gmail requires a third-party tool like Mail Merge for Gmail or Mailmodo.
  • Always send a test email to yourself first to check that placeholders are replaced correctly and formatting looks right.

Preparing Your Spreadsheet

Your data lives in a spreadsheet — Excel, Google Sheets, or CSV file. The spreadsheet must be organized in a specific way for mail merge to work. The first row holds column headers: FirstName, LastName, Email, CompanyName, or whatever fields you need. Every row below that is one recipient, with their data in the matching columns.

Keep these rules in mind: use consistent spelling in headers (Email, not email or EMAIL), put no blank rows between entries, and include every recipient in one contiguous block starting from row 2. If your data has blank cells — a person with no middle name, for example — that's fine; the placeholder just won't insert anything. But if you have a blank row in the middle of your list, mail merge will stop at that row and skip everyone below it.

Save the spreadsheet as .xlsx (Excel), .csv (comma-separated values), or keep it in Google Sheets. Different tools accept different formats, so check your mail merge tool's requirements before you start.

Creating Your Email Template

Write your email in your email client — Outlook, Gmail, or wherever you'll send from. The subject line and body are both part of the template. Anywhere you want to insert data from your spreadsheet, type the column header in double brackets: [FirstName], [Email], [CompanyName], and so on. These are your placeholders.

An example template might look like this: "Dear [FirstName], Thank you for registering for the workshop on [WorkshopDate]. Your confirmation code is [ConfirmationCode]. See you then." When mail merge runs, [FirstName] becomes "Sarah", [WorkshopDate] becomes "March 15", and [ConfirmationCode] becomes "WS-4829" — all pulled from the matching columns in your spreadsheet.

Format your email normally — use bold, italics, links, and images as you would in any message. Mail merge preserves formatting. The only thing that changes is the text inside the brackets.

Mail Merge in Microsoft Outlook

Outlook has mail merge built in, but it works differently than other tools. You don't set it up inside Outlook itself; instead, you use Word to create the template and connect it to your spreadsheet, then Word generates individual emails that Outlook sends.

Open Microsoft Word and go to Mailings > Start Mail Merge > Email Messages. Then click Select Recipients and choose your spreadsheet. In your Word document, type your email template and insert placeholders by going to Mailings > Insert Merge Field and selecting each field name from the dropdown. When you're ready, go to Mailings > Finish & Merge > Send Email Messages, choose which records to send to, and click OK. Word creates the emails and Outlook sends them.

This method works well if you already use Word and Outlook together, but it requires switching between programs. If you want to stay in Outlook, a third-party add-in like Mailmodo or Boomerang Mail Merge may be faster.

Mail Merge in Gmail

Gmail doesn't have native mail merge, so you'll need a third-party tool. The most common options are Mail Merge for Gmail (a free Chrome extension), Mailmodo, and Boomerang Mail Merge. All three work similarly: you install the extension, upload your spreadsheet, write your template in Gmail, and the tool sends personalized emails from your account.

To use Mail Merge for Gmail: install the extension from the Chrome Web Store, open Gmail, and click the Mail Merge icon in the compose window. Upload your spreadsheet and map each column to the fields in your template. Write your email with placeholders like [FirstName], then click Send. The extension sends one email per row in your spreadsheet, with placeholders replaced by actual data.

Paid tools like Mailmodo add features like scheduling, bounce detection, and detailed tracking, but the free version of Mail Merge for Gmail handles basic personalization. Check your email provider's terms — some limit how many emails you can send in a day to prevent spam.

Testing Before You Send

Before you send to your full list, send a test email to yourself. This catches mistakes: a misspelled placeholder name, a column header that doesn't match, formatting that broke, or data that didn't import correctly. Most mail merge tools let you preview the first few emails or send a test to a single address.

Open the test email and check that all placeholders were replaced with real data, that the message reads naturally, and that links and images display correctly. If something is wrong, go back to your spreadsheet or template, fix it, and test again. This takes five minutes and saves you from sending broken emails to hundreds of people.

Common Problems and How to Fix Them

Placeholders don't get replaced: The column header in your spreadsheet doesn't match the placeholder name in your template. If your spreadsheet has a column called "First Name" (with a space) but your template says [FirstName] (no space), mail merge won't find it. Check that names match exactly, including capitalization and spacing.

Some emails don't send: You have a blank row in the middle of your data, or a recipient's email address is missing or malformed. Mail merge stops at blank rows, so delete any empty rows between entries. Check that every recipient has a valid email address in the Email column.

Formatting looks wrong: Your template used special characters or formatting that your email client doesn't support. Test with a straightforward template first, then add formatting gradually. If you're using Outlook, compose in Word rather than Outlook directly, since Word handles complex formatting better.

Too many emails sent at once: Gmail and other providers limit how many emails you can send in a short time to prevent spam. If you're sending to thousands of people, space out your sends over several days, or use a tool like Mailmodo that can schedule sends automatically.

Frequently Asked Questions

Can I use mail merge with attachments?

Most mail merge tools don't attach different files to different emails — they attach the same file to everyone. If you need each recipient to get a different attachment (like a personalized PDF), you'll need a more advanced tool like Mailmodo or a custom script. For the same attachment to everyone, most tools support it.

What if I want to send emails at different times?

Native mail merge in Outlook and Gmail sends all emails when ready. Third-party tools like Mailmodo and Boomerang let you schedule sends for a specific time or spread them out over hours or days. If you need to send at different times to different people, you'll need one of these paid tools.

Can I see who opened the email or clicked a link?

Basic mail merge tools don't track opens or clicks. Gmail's native tracking is limited. Third-party tools like Mailmodo include tracking for opens, clicks, and replies. If tracking matters for your use case, choose a tool that includes it.

What happens if someone's name has special characters or accents?

Mail merge handles accented characters fine as long as your spreadsheet is saved in UTF-8 format, which is the default for most modern tools. If you see garbled text, check that your spreadsheet encoding is UTF-8 before you upload it.

Can I personalize the subject line too?

Yes. In your template, add placeholders to the subject line just like the body. Type something like "Your [EventName] confirmation code is [Code]" in the subject field, and mail merge will personalize it for each recipient.