The Mail Merge Alternative That Saves Every Record as Its Own File, Keeps Your Number Formats, and Grows Tables With Your Data

Even if you know Word mail merge inside out, the merge itself is rarely where the time goes. It's everything afterward: splitting a 100-page result into one file per person, fixing amounts that lost their commas, and adding table rows because every client has a different number of line items. If you've ever written a macro to split files, added format switches to every field, or wrestled with "Next Record" rules to cut that work down, you know exactly how tedious it gets.

merzing works the way you already do. It connects your Excel data to a Word or PowerPoint template. What changes is the output. Every record becomes its own file, named by rules you define. Amounts, dates, and codes appear exactly as they're formatted in Excel. And tables expand automatically to fit however many items each record has.

What Mail Merge Leaves Unfinished

Clicking "Finish & Merge" doesn't mean your documents are ready to send. Splitting the combined file, fixing the formatting, and cleaning up tables are all still waiting for you.

Certificates for 100 People Come Out as One 100-Page File

Word mail merge has no built-in way to save each record as a separate file. You're left cutting pages apart by hand or maintaining a VBA macro that few people on the team understand. And splitting the file isn't the end of it. Every file still has to be renamed and saved, one at a time.

$3,200.00 in Excel, 3200 in Your Document

Mail merge pulls the raw value stored in Excel, not the format you see in the cell. Currency loses its dollar sign and commas, a date shown as "March 1, 2025" turns into "3/1/2025", and a ZIP code like "02134" drops its leading zero and becomes "2134". The usual fix is to open the field codes and add a format switch to every single field.

Mail Merge Can't Grow a Table to Fit Your Data

Mail merge turns one row of Excel into one document, so it can't pull several rows of data into the same document. This is the classic one-to-many mail merge problem, and most real-world documents run into it: line items on quotes and invoices, earnings and deductions on pay stubs, subject grades on report cards. To make it harder, the number of rows each table needs changes from one record to the next.

What merzing Finishes in One Step

With merzing, the work is essentially done the moment you generate your documents. Files are already split by record and named by your rules. Amounts and dates keep the exact format they have in Excel, and tables gain a row for every repeating item. All that's left is a final review before you send.

Certificates for 100 People Come Out as 100 Separate Files

In merzing, every row in Excel becomes its own file. Generate certificates for 100 people and you get 100 individual files, bundled into a single ZIP download. Set a filename rule based on your Excel columns, and names like {{RecipientName}}_Certificate_{{IssueDate}}.docx are applied automatically. No cutting pages apart, no split macros to maintain, and no renaming a hundred files by hand.

$3,200.00 in Excel, $3,200.00 in Your Document

Unlike mail merge, merzing reads the format that's displayed in Excel. Currency keeps its dollar sign and commas, a date shown as "March 1, 2025" stays "March 1, 2025", and a ZIP code like "02134" keeps its leading "0". No more digging into field codes to add format switches. Want a different format? Change it in Excel, or set a custom date format right in merzing.

Table Rows Grow Automatically With Your Repeating Data

Wrap the table row that holds repeating data with markers like {#Items} … {/}, and merzing reads each record's data and adds exactly as many rows as it needs. A quote with 3 line items and one with 12 come from the same template, with no blank rows to delete and no missing rows to add. Even if client details and line items live in separate Excel files, you can link them through a shared column, such as a client ID, and pull both into one document.

Mail Merge for PowerPoint, Too

merzing handles PowerPoint (pptx) templates exactly the way it handles Word (docx). PowerPoint has no mail merge feature of its own, so certificates and proposals designed as slides have always meant editing one copy at a time. In merzing, you add variable names to your slides just as you would in a Word document, and every copy is generated at once. Whether your template is a Word document or a slide deck, you can use it exactly as it is.

Keep the Mail Merge Approach, Let merzing Handle the Tedious Work

Moving from mail merge to merzing takes almost no setup. Replace merge fields like «FirstName» in your current template with {{FirstName}}, then upload the same Excel file you've been using all along. There's nothing to install. Your Excel data is never sent to an external server; it's processed entirely inside the browser on your own computer, so there's no risk of it leaking through a third-party server. Your data stays exactly where it did with mail merge. The only thing that changes is that the manual cleanup after the merge disappears. Put the hours you spent splitting files and fixing formats back into the work that actually matters, and start today with a template you already use.