Skip to content
Sarudo

Bulk Mail Merge

Generating multiple personalized documents from a CSV data source with batch processing.

mail mergebulkbatchcsvpersonalizationmassdocuments

What is Mail Merge?

Mail merge generates multiple personalized documents from a single template and a data source (typically a CSV file). Each row in the CSV creates one document with the row's values filling in the template placeholders. This is perfect for generating personalized letters, invoices, certificates, contracts, or any document that needs to be customized for multiple recipients. Your AI employee handles the entire process from data to finished documents.

Preparing Your Data

Prepare a CSV file with column headers matching your template placeholders. For example, if your template uses {{name}}, {{company}}, and {{amount}}, your CSV should have columns named "name," "company," and "amount." Each row represents one document to be generated. Send the CSV to your AI employee along with the template name, and it will process the entire batch.

Running a mail merge

Generate multiple personalized documents.

You say:
[Attaches clients.csv with 25 rows] Use the invoice template to create invoices for all clients in this file.
Sarudo responds:
I've processed the mail merge. 25 invoices generated from the invoice template using your CSV data. Invoice numbers INV-2026-044 through INV-2026-068. Total value across all invoices: $127,500. All invoices are in PDF format. I can send them as a ZIP file, email them individually to each client, or both. What would you prefer?

Batch Processing

The mail merge engine processes documents in batch, generating all files efficiently. For large batches (100+ documents), the AI provides progress updates and estimated completion times. Generated documents can be delivered as individual files, bundled into a ZIP archive, or emailed directly to recipients if the CSV includes email addresses. The AI validates each row before processing and flags any missing data.

Always review a sample document before processing the full batch. Ask the AI to "generate just the first one for review" to verify the template fills correctly.

Email Mail Merge

Mail merge can extend beyond documents to personalized emails. Include an email column in your CSV, and the AI can send each generated document to its corresponding recipient. Each email follows the standard approval workflow — the AI will show you a sample email and ask for approval before sending the batch. This is powerful for sending personalized invoices, contracts, or marketing materials to multiple contacts at once.