Mail merge lets you send the same email to many people with each one personalized with their name, company, or other details
Mail merge is a feature that pulls information from a list — usually names, email addresses, and other details stored in a spreadsheet or database — and automatically inserts that information into an email template. Instead of typing "Dear John" in one email, "Dear Sarah" in another, and so on, you write the email once with a placeholder like "Dear [First Name]", and the mail merge tool fills in each person's actual name before sending.
The result is that 500 people each receive an email that feels personally addressed to them, even though you only wrote it once. Mail merge is built into most email platforms and office software — Microsoft Outlook, Gmail, Google Workspace, and Apple Mail all have versions of it. Some are easier to set up than others, but the basic idea is the same across all of them.
Key Takeaways
- Mail merge pulls names and other details from a spreadsheet and inserts them into a template email, so each recipient sees their own information without you typing it separately.
- You need two things to start: an email template with placeholders (like [First Name]) and a data file with the actual information organized in columns.
- Microsoft Outlook's mail merge is built into the software, while Gmail requires a free add-on like Mail Merge by Gmail or Mailmodo to do the same job.
- Mail merge works best for one-time sends to a large group — newsletters, announcements, or follow-ups — not for ongoing back-and-forth conversations.
How mail merge actually works in practice
The process has three steps. First, you create a spreadsheet with your data organized in columns — one column for first names, one for last names, one for email addresses, one for company names, or whatever details you need. Each row is one person. Save this file as a .csv (comma-separated values) or .xlsx file, depending on what your email tool accepts.
Second, you write your email template in your email platform. Instead of typing an actual name, you type a placeholder in curly brackets or square brackets — the exact format depends on which tool you are using. In Outlook, you might write "Dear {{FirstName}}, thank you for attending our event." In Gmail with an add-on, the format might be slightly different, but the idea is the same.
Third, you tell the mail merge tool where your data file is and which column matches which placeholder. The tool then creates a separate email for each row in your spreadsheet, fills in the placeholders with the actual data, and sends them all. Most tools let you preview a few examples before you hit send, so you can catch mistakes.
Mail merge in Microsoft Outlook versus Gmail
Microsoft Outlook has mail merge built directly into the software. You go to the Mailings tab, click Start Mail Merge, choose your data source (the spreadsheet), and then insert merge fields into your email. Outlook is straightforward if you already use it for email, but the feature is less visible than other Outlook functions, so many people do not know it exists.
Gmail does not have mail merge built in, but you can add it through free extensions. Mail Merge by Gmail and Mailmodo are the most common. You install the add-on, write your template in Gmail, upload your spreadsheet, and send. The add-ons work well, but they add an extra step compared to Outlook, and you are relying on a third-party tool rather than something built into Google's own software.
Apple Mail does not have a native mail merge feature. If you use Apple Mail, you would need to use a third-party tool or switch to Outlook or Gmail for this particular task. Many people in that situation use a web-based mail merge service instead, which works with any email provider.
When mail merge makes sense and when it does not
Mail merge is most useful when you have a large group to contact at once and you want each person to feel like the message was written for them. Common uses include sending event invitations with each person's name, notifying customers of a change with their account number included, or following up with a list of leads where you want to mention their company name.
Mail merge is less useful for ongoing conversations. If you send a mail merge email and people reply, you will get individual responses that you have to handle one at a time — there is no automation on the reply side. It is also not the right tool if you need to send different content to different groups. If half your list should get one message and half should get another, you would run mail merge twice, not once.
Mail merge also requires that your data be clean and organized. If your spreadsheet has typos, missing information, or inconsistent formatting, those mistakes will appear in every email that goes out. Spending time cleaning up your data before you start is worth it.
Setting up your data file correctly
The most common mistake people make with mail merge is not organizing their data file properly. Your spreadsheet should have headers in the first row — "First Name", "Last Name", "Email Address", "Company" — and then one person per row below that. Each column should contain only one type of information. Do not put "John Smith" in one cell if you need to use first and last names separately in your email.
Check for extra spaces before or after names, inconsistent capitalization, and blank cells. If a cell is empty, some mail merge tools will leave a blank space in your email, which looks odd. Others will skip that merge field entirely. Test with a few rows first to see how your tool handles missing data, then decide whether to fill in blanks or adjust your template.
Save your file as .csv or .xlsx depending on what your email tool accepts. Most tools accept both, but check the documentation for the specific add-on or software you are using. Once your file is ready, you can reuse it for future mail merges — just update the data and run the merge again.
Common problems and how to fix them
The most common problem is that merge fields do not match the column headers in your data file. If your spreadsheet has a column called "First_Name" but your template uses [FirstName], the tool will not know which column to pull from and will leave that field blank. Check that your placeholder names match your column headers exactly, including capitalization and spacing.
Another frequent issue is sending a test email to your entire list by accident. Most mail merge tools let you preview one or two examples before sending to everyone. Use that preview feature every time. If you do send by mistake, there is no undo — the emails are already in people's inboxes.
Some people also forget to remove test data from their spreadsheet before running the merge. If you added a row with "Test Person" and "test@example.com" while setting things up, that person will receive an email too. Clean up your data file before you start the actual send.
Frequently Asked Questions
Can I use mail merge to send different emails to different groups?
Not in a single merge. You would need to split your spreadsheet into separate files — one for each group — and run mail merge once for each file. Some advanced tools let you add conditional logic so that different text appears based on a column value, but most standard mail merge features do not support this.
What happens if someone's email address is wrong in my spreadsheet?
The email will bounce back to you as undeliverable. Mail merge does not validate email addresses before sending, so it is your responsibility to make sure the addresses are correct. Check a sample of addresses in your spreadsheet before you run the merge.
Can I schedule a mail merge to send at a specific time?
It depends on your tool. Outlook lets you delay delivery on individual emails, but not on a whole mail merge batch. Gmail add-ons vary — some have scheduling built in, others do not. Check the documentation for the specific tool you are using.
Is mail merge the same as a mailing list or newsletter?
No. A mailing list or newsletter service like Mailchimp or Substack is designed for ongoing communication with subscribers. Mail merge is for one-time or occasional sends where you want personalization. Mailing list services have better tracking, unsubscribe handling, and compliance features for regular sends.
Can I include attachments in a mail merge email?
Yes, but the same attachment goes to everyone. You cannot use mail merge to send different attachments to different people based on your data file. If you need to send different files to different recipients, you would need a more advanced tool or a custom solution.