Mail merge a contract, then get every copy signed
A Word mail merge is great at producing fifty personalized letters, and then it stops: someone still has to send each one, chase it and file the signed copy. A SignMaster bulk send does the merge and the signing together, so every spreadsheet row becomes a contract that goes out and comes back signed.
Updated November 5, 2026 · 3 min read
On this page
How a contract mail merge works
A classic mail merge has three parts: a main document with placeholders, a data source with one row per person, and the merge that combines them. SignMaster keeps the same three parts and adds signing on top. The main document is a template, the placeholders are labeled boxes on it, the data source is a CSV, and the merge is a bulk send that makes one envelope per row.
| Word mail merge | SignMaster bulk send | |
|---|---|---|
| Main document | A Word file with merge fields | A template made from your PDF or Word file |
| Placeholders | Merge fields such as First_Name or Fee | Labeled text boxes and prefilled fields |
| Output | Letters to print or email | One envelope per row, each with a private signing link |
| Signatures | Printed, signed and scanned back | Signed on any phone or computer, tracked row by row |
Two kinds of merge field
For each detail that changes from copy to copy, decide: may the signer change it?
- Text boxes print as fixed wording. In the template, pick Text from the Markup toolbar, draw the box where the detail belongs and give it a label such as Annual fee. Bulk send fills it from the column with the same name, and the signer reads it as part of the contract, unable to edit it.
- Prefilled fields stay editable. A signer's own text, name, phone, date or number field can be filled from a column too. The value is waiting when they open the link and they can correct it, which suits a mailing address you aren't sure is current.
Matching is forgiving. Capitals, spaces and punctuation are ignored, and a few everyday names count as the same thing, so a column called Client name fills a field labeled Customer name.
Run the merge
- 1
Build the template once
Upload the contract, add a signer role for the person on each row, place their signature fields, and add a labeled box for every detail that changes.
- 2
Start from the right headers
On the template, choose Bulk send, then Download a blank CSV. Its headers already match your role names and labels, so paste your list under them instead of renaming columns by hand.
- 3
One row per contract
Each row holds the person's name and email, then the values for their copy. If the list came from Excel, save it as CSV UTF-8 so accented names come through intact.
- 4
Upload, match and check
Upload the file or paste the rows. SignMaster matches each column to a role or a label and checks every row before anything goes out: a bad email or a value its field won't accept is listed with the reason. A text-box value too wide for its box fails when that row sends.
- 5
Send the batch
Set reminders, expiry and the signing order once for the whole batch. You can add each person's name to their envelope's title, so your list reads Service agreement – Dana Ruiz rather than fifty identical titles.
Mistakes that spoil a merge
- A label with no matching column. That box goes out empty on every copy. Download the blank CSV again after your last template change, so the headers are current.
- Spreadsheet formatting. Excel drops the leading zero from a ZIP code like 02134 unless the column is formatted as text. Open the CSV in a plain text editor and check a few rows before you upload.
- A price in a prefilled field. If the signer shouldn't be able to change it, it belongs in a text box.
- One giant file. Each send takes up to 250 rows on Solo, 500 on Crew and 1000 on Company. Split a longer list into a few files.
After the merge
Every row is now its own envelope, with its own reminders, signed PDF and certificate. The batch page's results CSV lists every row with an envelope link and status. To see what people filled in across the merge, open the template's Responses tab and filter it to this bulk send: all answers to a template in one table.
Questions? Answers.
Can I use my Word mail merge document?
Not its merge fields. Upload the Word file as a template (SignMaster converts it to PDF), then add a labeled text box wherever a merge field used to be.
Can a row change whole sentences, not just names?
Yes. A text box can hold a clause as easily as a name, so one row can carry its own payment terms or scope of work while the rest of the contract stays the same.
Does each person see the others on the list?
No. Each row is a separate envelope with its own private link, and nobody sees another person's copy or values.
Do I need a paid plan to mail merge?
Yes. Bulk send is on Solo, Crew and Company. Compare plans.