- © 2026 Mailsoftly Inc. The name "Mailsoftly" and the Mailsoftly logo are registered trademarks of Mailsoftly Inc.
by Isabella Torres · Last updated: 2026-09-30Mail merge is a feature that automatically combines a single template with a structured data source, such as a spreadsheet of names and addresses, to produce many personalized documents or emails at once. Instead of editing each message by hand, you write one template with placeholders, and the software fills in unique details for every recipient.
The concept started with printed letters and address labels, but today most mail merge happens in email. Whether you are sending 20 personalized invoices or 2,000 outreach emails, the principle is identical: write once, personalize everywhere, send in a single batch. Modern tools such as mail merge for emails and documents in Mailsoftly carry the same idea further, into the subject line, into sentences only some people see, and into a separate PDF for each recipient.
New here? Start with our primer on Email Marketing Fundamentals for the fundamentals, then come back to this guide.
Sending a mail merge to more than a few dozen people? Gmail and Outlook cap how many recipients you can reach in a day and show you nothing about opens or clicks. Mailsoftly sends personalized emails to your whole list with tracking, free up to 500 contacts and 2,000 emails a month with your Gmail, Outlook, Google Workspace or Microsoft 365 account, no credit card.
Start free with Mailsoftly →
Key Takeaways
Mail merge is the process of generating many personalized outputs from one template plus one list. You define a master document with placeholder fields, connect it to a data source where each row is a recipient, and the program produces a unique, finished version for every row automatically.
Think of a wedding invitation. You write the invitation text once, but each card needs a different guest name. Mail merge lets you keep the shared text constant while swapping in “Dear Sarah,” “Dear Marcus,” and “Dear Priya” across hundreds of copies without retyping a single word. The same logic powers personalized billing emails, shipping notifications, and cold outreach.
Read enough? Try Mailsoftly free with 500 contacts and 2,000 emails per month with your Gmail, Outlook, Google Workspace or Microsoft 365 account, no credit card.Start free with Mailsoftly →
Mail merge works by mapping columns from your data source to placeholder fields in your template, then looping through every row to produce a finished copy. The software substitutes each placeholder with the matching cell value, so one row equals one personalized output.
The exact buttons differ between Word, Gmail, and a dedicated email tool, but the underlying workflow is always the same five steps. Get these right and the rest is automatic.
A common mistake is leaving blank cells in your data source. If a recipient has no company value, the merge prints “Hi Sarah, your order from ships today.” Clean your list first, then plan for the gaps that remain: a fallback swaps in replacement text, and conditional text removes the whole sentence for anyone missing the value. Both are covered in advanced mail merge techniques below.
Mail merge is used anywhere you need the same message delivered with individual details at volume. The most common applications fall into personalized correspondence, transactional documents, and one-to-many outreach.
Mail merge also produces documents, not just messages. Certificates of completion, renewal letters, donor receipts and account statements are classic merges, and the modern version builds one PDF per person and sends it with that person’s email, instead of printing a stack of letters or splitting one long merged file by hand.
Personalization is not cosmetic. Marketers consistently report that segmented, personalized sends outperform generic blasts, and HubSpot documents how relevance drives stronger engagement across email programs. Mail merge is the simplest on-ramp to that relevance because it turns one list into hundreds of individually addressed messages.
You can run a mail merge with office software you already own or with a dedicated email platform built for volume. The right choice depends on batch size, whether you need delivery tracking, and how much deliverability matters.
| Tool | Best for | Tracks opens? | Scales to thousands? |
|---|---|---|---|
| Word plus Excel | Printed letters and labels | No | Print only |
| Gmail plus an add-on | Small email batches | Limited | Daily caps apply |
| Dedicated mail merge tool | Outreach with tracking | Yes | Yes |
| Email marketing platform | Ongoing campaigns and automation | Yes | Yes |
For paper letters and labels, the classic Word plus Excel combination is hard to beat. For email, a purpose-built option such as a Mail Merge Tool gives you placeholders, previews, and delivery reporting without the daily limits or deliverability risk of sending from a personal inbox. Before you pick one, check how each tool handles an empty field and whether it can send a different document to each person, because that is where the options differ most.
If mail merge is becoming a recurring need rather than a one-off task, a full email marketing software platform adds list management, automation, and analytics on top of the merge itself. That is the natural upgrade path once you are sending personalized email every week.
Advanced mail merge techniques handle what a plain name swap cannot: empty fields, sentences that only fit some people, and documents that differ for every recipient. The five below cover most real lists. The examples use Mailsoftly’s merge tag syntax, where a field sits inside {( )}, but the ideas apply to any serious mail merge tool.
A fallback prints replacement text when a field is blank. {(first_name OR "there")} reads “Hi Emily” for Emily and “Hi there” for anyone without a first name on file. Write the fallback for the whole phrase, not just the word, so both versions read naturally.
Conditional text prints a sentence, a plural or a whole paragraph only for recipients who have a value. Wrap it in an IF block, {(IF Seats booked)} We are holding your seats. {(END)}, and everyone else simply does not see it. {(IF NOT Seats booked)} covers the people who are missing the value, and {(ELSE)} gives you both branches in one place. For separators, {(Order2 PREFIX ", ")} adds the comma only when a second order exists, so one order or two both read cleanly. In a drag and drop email, a whole row can carry a display condition such as “Show only if the field is filled”.
You do not have to memorize any of it. In Mailsoftly the Personalize menu lists every contact field, plus a Handle empty fields group that inserts the fallback, PREFIX and IF forms for you, and the editor shows each tag as a labelled chip.
The document side of mail merge has moved into email too. Instead of merging letters in Word, saving one long file and splitting it, a personalized attachment turns a saved template into one PDF per recipient at send time, filled in with that person’s fields. The file name merges as well, so a file named Thank You {(first_name)} arrives as each person’s own file. Shared files that everyone should get, such as an event schedule, can travel alongside it. The mail merge with attachments guide walks through the whole workflow.
A statement or a letter with an account number should not sit in an inbox where a forward exposes it. Secure link delivery sends a personal link instead of the file: the recipient confirms an access code, or a detail you already hold such as a member number, before their PDF opens. The code travels separately, for example in a second email or a text message. A PDF attached directly to an email cannot be password protected, which is why the link exists.
Large attachments slow a send down and trip spam filters, so brochures, price lists and video clips work better as a link to a file gallery. The link is the same for everyone and opens the file, or plays the video, in the reader’s browser. Before anything goes out, open a few real recipients, one with every field filled and one with gaps, and read their exact copy and their PDF. That check catches almost every merge mistake.
These techniques are what separate a mail merge that looks personal from one that only looks automated. The merge tags guide covers every form in detail.
Traditional mail merge breaks down once you need scale, tracking, or reliable inbox placement. It was designed to print documents, not to manage modern email programs, so four gaps appear as your sending grows.
These gaps are exactly why growing senders move from a spreadsheet merge to a dedicated platform. Mailsoftly’s free plan includes 500 contacts and 2,000 emails per month with your Gmail, Outlook, Google Workspace or Microsoft 365 account (as of September 2026), with paid plans starting at $15 per month billed annually for 1,000 contacts and Basic at $39 for 5,000 contacts. You keep the simplicity of merge fields while gaining open tracking, automatic unsubscribe handling, and the sending infrastructure that protects your inbox placement.
The decision is rarely “mail merge or not.” It is “how much sending volume justifies a real platform.” If you send the same personalized email more than once a month, the analytics and deliverability alone usually pay for the upgrade.
If you want to try the full version of this workflow, conditional text and a personal PDF included, see how mail merge works in Mailsoftly. The ideas in this guide apply whichever tool you choose.
For the broader picture on this topic, see our complete Email Marketing Fundamentals guide, which covers strategy, fundamentals, and advanced playbooks.
Mail merge works in three parts: a template with placeholders, a data source such as a spreadsheet where each row is one recipient, and a merge engine that fills the placeholders with each row’s values. The software repeats this for every row, producing one personalized document or email per recipient, ready to print, save, or send.
Mail merge is the technique of merging one template with a data list to produce personalized outputs. Email marketing is the broader practice that uses that technique inside a platform with list management, automation, analytics, and compliance tools. Mail merge is a single step; email marketing is the full program around it.
Yes, basic mail merge is free if you already have Microsoft Word and Excel, or a Gmail account with a free add-on. For larger email batches with tracking and deliverability protection, dedicated tools offer free tiers too. Mailsoftly’s free plan covers 500 contacts and 2,000 emails per month with your Gmail, Outlook, Google Workspace or Microsoft 365 account with no credit card required.
A document merge in Word can handle thousands of printed pages. Email merges are different: sending from a personal Gmail account is capped at a few hundred messages per day, while a dedicated email platform can deliver thousands in a single batch with proper authentication and deliverability controls.
It can, especially when you send a large batch from a personal inbox without authentication. Spam filters flag sudden volume spikes and missing opt-out links. A dedicated platform with verified domains, automatic unsubscribe handling, and reputation monitoring keeps personalized emails landing in the inbox far more reliably.
Conditional text is a sentence or paragraph that appears only for recipients who have a certain value. In Mailsoftly you wrap it in an IF block, such as {(IF Seats booked)} ... {(END)}, and add {(IF NOT ...)} or {(ELSE)} for everyone else. It keeps one template correct for people with complete records and people with gaps.
Yes, with a tool that builds documents at send time. In Mailsoftly a personalized attachment turns a saved template into one PDF per recipient, filled with their fields and named after them, then attaches it or sends it behind a secure link. It works for lists of up to 5,000 recipients and is switched on per account by the support team.
Yes, as a link. Upload the clip, for example an MP4 up to 25 MB, to a file gallery and link it from the email; it plays in the reader’s browser and keeps the email light. Everyone gets the same video link, while the text around it can still be personalized.
Send your next mail merge with tracking and personalizationStart free with Mailsoftly →
500 contacts, 2,000 emails per month with your Gmail, Outlook, Google Workspace or Microsoft 365 account. Merge fields and open tracking included. No credit card.
Ready to boost your email marketing?
Send beautiful, targeted emails that convert. Free plan available, paid plans from $15 a month.
Try Mailsoftly FreeNo credit card required