Mail Merger — One mail body per CSV row

1. What does this tool do

This free online mail merger lets you generate many mail bodies from one template and a CSV file. Type a mail template with placeholders (e.g. {{name}}, {{email}}), upload a CSV whose column names match those placeholders, then click Merge to get one mail body per row. All processing runs in your browser—no sign-up, no server upload. Ideal for newsletters, invitations, or bulk personalization.

2. How to use it

Quick start: Type or paste your mail template in the template box, using {{fieldName}} for each value that will come from the CSV. Upload a CSV file whose first row has column names matching those fields. Click Merge to generate all mail bodies. Copy or download the results.

1. Enter the mail template — In the template box, write your message and use {{name}}, {{email}}, or any {{fieldName}} that matches your CSV columns. The tool shows detected fields below the box.
2. Upload a CSV — Click Upload CSV and choose a file. The first row must be headers (e.g. name, email). A preview and column list appear; you’ll see a warning if the template uses a field that has no matching column.
3. Merge — Click Merge. One mail body is generated per CSV row, with placeholders replaced by that row’s values. Missing columns are replaced with nothing.
4. Copy or download — Copy a single mail, Copy all, or Download all as a single text file (mails separated by a delimiter).

3. How it works

The tool parses your template for placeholders (e.g. \{\{([a-zA-Z0-9_]+)\}\}) and parses the CSV (first row = headers, following rows = data). Each row is turned into a record keyed by normalized column names (trimmed, lowercased). For each row, every placeholder in the template is replaced by the value for that key (or empty if missing). The result is one string per row. All processing is client-side in your browser; no data is sent to any server.

4. Use cases & examples

• Newsletters — One template, many recipients; personalize with name, company, or custom fields from a spreadsheet.
• Invitations — Same message, different names and details; export or copy each body into your mail client.
• Bulk mail — One template, many bodies from CSV rows; copy all or download for use elsewhere.

Example

• Template: Hello {{name}}, your order {{orderId}} is ready.
• CSV: name,orderId then rows Alice,123 and Bob,456.
• Result: Mail 1 = "Hello Alice, your order 123 is ready."; Mail 2 = "Hello Bob, your order 456 is ready."

5. Limitations & known constraints

• Plain text — The template and output are plain text; no HTML or rich formatting.
• CSV only — Data must be in CSV format; first row = headers. Quoted fields and commas inside quotes are supported.
• Browser memory — Very large CSVs (e.g. hundreds of thousands of rows) may slow or exceed practical limits.
• No sending — The tool only generates mail bodies; it does not send email. Copy or download and use your own mail client or service.