Skip to content

Mail merge vs document automation: which one do you need?

Published · Updated · Automating Word templates

Word's mail merge is free and already on your computer. For some documents it is all you need. For others it becomes a maze of copies and manual edits. Here is how to tell the difference.

What mail merge does well

Mail merge takes rows from a spreadsheet and fills the same blanks in the same document: a name, an address, an amount. It is ideal for the same letter to many people, such as a price-change notice to 300 customers.

Where mail merge runs out

  • Optional clauses. A retainer paragraph that applies to some clients and not others means keeping two versions of the document, or deleting text by hand afterwards.
  • Lists of different lengths. One matter has one attorney, the next has four. Mail merge has no natural way to repeat a paragraph or a table row per item.
  • Either/or wording. "Remote" versus "based at our London office", or past versus present tense in a verification letter.
  • Calculations. Totals, dates 30 days after signing, amounts in words.
  • Guidance for the person filling it in. A spreadsheet column has no help text, no validation and no way to hide questions that do not apply.

What document automation adds

Document automation turns a template into a questionnaire. Each answer can fill a blank, switch a clause on or off, repeat a block for each item in a list, or feed a calculation. The person drafting answers questions instead of editing a document, and the output is consistent every time.

A quick test

If every copy of your document has exactly the same paragraphs, use mail merge. If you ever delete, copy or rewrite paragraphs after merging, you need document automation.

Trying it on your own document

Clausery uses tags you type straight into Word, so your mail merge template is already most of the way there. Replace merge fields with tags like {client_name}, wrap optional paragraphs in {#has_retainer}…{/has_retainer}, and drop the file into the app. It is free for up to three of your own templates and nothing is uploaded. The step-by-step guide walks through it.

More on automating Word templates

All guides

NDAs and restrictive covenants

Hiring and HR letters

Freelancing and getting paid

Landlords and tenants

Business deals, money and releases