Mail Merge in Writer

Word & PowerPoint Chapter 7 established the underlying job: one template, one data source, many personalized documents. That job hasn't changed. What's genuinely different here is the flow — Writer walks you through it with a guided, step-by-step Mail Merge Wizard, rather than the more free-form, Ribbon-driven process Word uses.

The Same Job, a Different Flow: The Mail Merge Wizard

Tools → Mail Merge Wizard opens an 8-step guided sequence: select a starting document, choose the document type (letter or email), insert an address block, create a salutation, adjust the layout, edit merge fields directly if needed, personalize and preview the documents, then complete the merge. Word offers the same overall set of decisions, just made in whichever order you choose from its Mailings tab rather than a fixed guided sequence.

Choosing the Data Source

Within the wizard, Select Address List connects to your data — a Calc spreadsheet (.ods or .xlsx), or an external database registered with LibreOffice. This is genuinely broader than Word's own merge, which is built primarily around file-based sources; Writer's merge is designed from the ground up to work against real database connections too, not just spreadsheet files.

The Registered Data Sources Concept

Writer's merge mechanism is built around registering a data source with LibreOffice first — giving it a name LibreOffice remembers (via Tools → Options → LibreOffice Base → Databases, or File → New → Database) — rather than browsing fresh to a file every single time, the way Word's Select Recipients → Use an Existing List does. Once registered, that same named data source can be reused across multiple merge documents without ever re-browsing to the underlying file again.

Address Block and Salutation: Built-In Smart Matching

Steps 3 and 4 of the wizard attempt to automatically match your data source's own column names to the fields an address block or salutation expects — a "Match Fields"-style step conceptually identical to Word & PowerPoint Chapter 7's own Match Fields dialog, and driven by the exact same underlying concern: column names that don't match exactly need to be explicitly mapped, or the merge silently produces blank or mismatched results.

Inserting Additional Merge Fields Manually

Insert → Field → More Fields → Database tab (also reachable directly from within the wizard) lets you place any specific column's value anywhere in the document — the same underlying action as Word's Insert Merge Field, just reached through a general-purpose Field dialog rather than one dedicated Ribbon button.

Personalizing and Completing the Merge

The wizard's later steps preview each record's actual data filled into the document — the same purpose as Word's own Preview Results — before finishing by printing directly, saving the merge as one combined document, or emailing each personalized copy: the same three completion options Word & PowerPoint Chapter 7's Finish & Merge offers.

Hands-On Exercises