Mail merge for emails and documents

Write it once. Every contact gets their own email, and their own PDF.

Mailsoftly merges each contact's details into the subject and the body, shows a sentence only to the people it fits, and can build a personal PDF letter or certificate for every recipient, attached or behind a secure link. Brochures and video clips ride along as a light link.
Free to start with your Google Workspace or Microsoft 365 account · No credit card required
Mailsoftly simple email editor with a mail merge draft to a 4,089 contact list: merge fields shown as labelled chips such as First name with a fallback, and If and If no chips that show a sentence only to recipients who have a value
The Delivery choice for a personalized PDF in a Mailsoftly mail merge: attach the PDF to the email or send each recipient a secure link
The Mailsoftly attachments card with shared files for everyone and a personalized PDF per recipient named Thank You first name
1 personalized PDF · 2 shared files
Join thousands of businesses
5.0
4.3
4.9
5.0
5.0
What you can merge

Far more than a first name

A mail merge in Mailsoftly reaches every part of the send: the subject, the body, the sentences that should only appear for some people, and the documents and files that go with the email.
✉
Email

Subject and preview text

Put a name, an order number or a renewal date in the subject line and the inbox preview. A small question mark beside the subject spells out what each person will read, fallback included.

✎
Email

Every line of the body

Every column you import, custom fields included, becomes a merge tag you can drop into the simple editor or the drag and drop editor. The wider playbook lives on the email personalization page.

⚙
Conditions

Text only for the people it fits

IF, IF NOT and ELSE show a sentence, a plural or a whole row only to recipients who have the value. PREFIX and SUFFIX keep commas from dangling when a field is empty.

📄
Documents

A personal PDF for each recipient

Letters, certificates, statements and thank you notes, built from a saved template and filled in with each person's fields. The file name merges too.

🔒
Documents

Secure document links

Keep sensitive PDFs out of the inbox. Each person gets a personal link and confirms an access code or a detail on file before their document opens.

▶
Files

Files and video by link

Brochures, price lists and MP4 clips from your file gallery go out as one light link that opens in the browser, so the merged email stays easy to deliver.

Conditional text

Write for the full record and the empty cell

Real lists have gaps. Someone has no first name on file, someone booked seats and someone did not. Merge tags in Mailsoftly carry the rules for both cases, so every copy reads like it was written for that one person.
Fallbacks{(first_name OR "there")} reads "Hi Maria" for Maria and "Hi there" for anyone without a name.
IF, IF NOT and ELSE{(IF Seats booked)} ... {(END)} prints a whole sentence only for people who have the value, and {(IF NOT ...)} covers everyone else.
PREFIX and SUFFIX{(Order2 PREFIX ", ")} adds the comma only when a second order exists, so one order or two both read cleanly.
Rows that hide themselvesIn the drag and drop editor, a row's display condition, "Show only if the field is filled", hides it for anyone with an empty value.
No syntax to memorizeIn the editor every field shows up as a labelled chip, such as First name or If Seats booked, so you read the email, not code. The Personalize menu lists every contact and custom field, plus a Handle empty fields group that inserts each rule for you. The merge tags guide covers every form.
The Mailsoftly Personalize menu listing custom merge fields and a Handle empty fields group with fallback, PREFIX and IF END tags
Personalized documents

One campaign, one PDF per person

Turn any saved template into a document that is built for each recipient at send time: a renewal letter with their member number, a certificate with their name, a thank you note that mentions what they gave. It rides with the same merged email.
Any template becomes the documentPick a saved template, whichever editor made it, and write it with the same merge tags as the email.
The file name merges tooThank You {(first_name)} becomes a separate file for every recipient, up to 120 characters.
Attached, or behind a secure linkAttach the PDF to the email, or send a personal link that asks for an access code or a detail on file first. Shared files that everyone gets can sit alongside.
Built at send timeWith Attach the PDF, nothing is stored afterward. With a secure link, the file stays encrypted in private storage while the link works, so you can see who opened it and resend.
Run a mail merge for emails and documents →
The Mailsoftly attachments card on a mail merge campaign: two shared files for everyone, a personalized Thank You Note PDF per recipient with a merged file name, and the choice to attach the PDF or send a secure link
Check every copy

See what each person gets before it goes

Step through real recipients, not a test record. Open anyone's email, page through their PDF, and after the send, follow every secure document to see who opened it.
Each email
Each PDF
Secure documents
Recipient view
The Mailsoftly recipient preview listing each contact who will receive their own merged copy of the campaign
Recipients: search anyone who will get the campaign, then open the exact copy they will receive, merge fields filled in.
Files and video

Share a clip or a brochure without the weight

Big attachments slow a send down and trip spam filters. Upload the file to your gallery once and the merged email carries a link instead, which opens the file, or plays the video, in the reader's browser.
Documents, audio and videoPDF, DOC, XLS, PPT, CSV, PNG, JPG, ZIP, MP3 and MP4, up to 25 MB per file.
In both editorsThe paperclip in the simple editor opens your gallery, and any button, image or text link in the drag and drop editor can point to a gallery file.
Links that keep workingRename it, file it in a folder or delete it from your gallery, and links already in inboxes still open.
Share a file link in your email →
The Mailsoftly file gallery open over the simple email editor, listing PDF, CSV, MP3 and MP4 video files to add to a mail merge as a link
From spreadsheet to send

Three steps from a list of names to individual emails

No add-on, no copy and paste, no separate document tool. The list, the email, the documents and the send all live in one place.
↑ Import your list

Your columns become fields

Upload a spreadsheet or paste the rows, then map each column. Anything that is not a built-in field becomes a custom field on the spot, ready to merge. Manage it all in contact management.

✎ Write it once

Tags, conditions and a PDF

Write the email the way you would to one person, insert tags from the Personalize menu, and add a personalized attachment if the send needs a document.

✉ Preview, then send

Check the tricky records

Open the contact with the empty field and the one with every field, then send to the whole list or a segment as an email blast. Each person gets their own copy.

Watch it done

Mail merge from wherever your list lives today

Short, narrated walk-throughs of real merges in Mailsoftly, whether you work in Gmail, Outlook or Excel today.
Gmail mail merge without an add-on2:17 · Read the walk-through
Mail merge from Excel to email2:25 · Read the walk-through
Outlook mail merge with attachments2:01 · Read the guide
Mail merge certificates1:41 · Read the guide
Protect each PDF with an access code2:27 · Read the walk-through
Send an email to many people individually1:07 · Read the guide
FAQ

Mail merge, answered

What is a mail merge for email?

A mail merge for email takes one message and one list and produces an individual copy for every contact, each filled in with that person's details. In Mailsoftly the merge reaches the subject line, the preview text, the body and, when you need one, a PDF document built for each recipient, so a letter or certificate can go out in the same send.

How do I do a mail merge in Mailsoftly?

Import your contacts from a spreadsheet so each column becomes a field. Create a campaign, write it once, and insert merge tags from the Personalize menu wherever a personal detail belongs. Add a personalized attachment if the send needs a document, preview a few recipients, then send to your whole list or a segment. There is no add-on to install and no separate document tool.

Can I attach a different PDF to each recipient?

Yes. A personalized attachment turns any saved template into one PDF per recipient, filled in with their own fields, and the file name can merge too. You choose whether the PDF is attached to the email or sent behind a personal secure link. Personalized attachments work for lists of up to 5,000 recipients and are switched on per account by our support team, so ask support if you do not see the Attachments card on your campaign.

Can I show a sentence only to some recipients?

Yes. Wrap it in an IF block, such as {(IF Seats booked)} ... {(END)}, and only recipients who have that value see it. IF NOT covers everyone who is missing it, and ELSE gives you both branches in one place. In the drag and drop editor you can also give a whole row a display condition so it only shows when a field is filled.

What happens when a contact is missing a field?

You decide. A fallback shows replacement text, so {(first_name OR "there")} becomes "there" for anyone without a first name. PREFIX and SUFFIX print a separator only when the value exists, and an IF block hides a whole passage when it is empty. Nobody gets a dangling comma or an empty sentence. The merge tags guide walks through each form.

Can I send a password protected PDF in a mail merge?

For sensitive documents, choose Secure link as the delivery. Each recipient gets a personal link and confirms an access code we generate, or a detail you have on file, before their PDF opens, and you can also lock the downloaded file with that same code. Send the code separately, for example in a second email, with its own merge tag. A PDF attached directly to the email is not password protected, which is why the secure link exists.

Can I include a video or a large file in a mail merge?

Yes, as a link. Upload the file to your Mailsoftly file gallery, up to 25 MB per file, including MP4 video, and add its link to the email with the paperclip in the simple editor or a file link in the drag and drop editor. The file opens, or the video plays, in the reader's browser, and the email stays light. Gallery storage is 100 MB on the free plan and 1 GB on paid plans.

Is mail merge free to start?

Yes. Create your account free with Google or Microsoft sign-in and run mail merges on the free plan, no credit card required. Google Workspace and Microsoft 365 accounts get the quickest start; personal Gmail or Outlook.com works too, with lower sending limits while your account builds trust. Paid plans add higher sending volumes.

Send the letters, certificates and notes in one go

Sign up free with your Google Workspace or Microsoft 365 account, import your list, and send one campaign that reaches everyone by name, with their own document attached.

Start free with Google Start free with Microsoft 365
No credit card required · Cancel anytime · Real humans on support