4.1Mail Merge & Mailing
The essentials in 30 seconds
- Mail Merge merges a Word template with a data source to create mass personalized documents.
- Excel is the most common source: headers in line 1, no merged cells, file closed before connection.
- The Mail Merge Wizard guides the 5 steps: type, source, fields, preview, finalization.
Fil Imane — Direct mail & mailing
Imane is preparing an invitation campaign for partner carriers. It connects an Excel file, inserts the merge fields, adds a conditional rule and generates the custom letters.
Continuation of the common thread: a logistics SME in Algiers professionalizes its documents.
1. Principle of direct mail
Mail merge allows you to automatically generate numerous personalized documents from a single template and a database. Concretely, Word replaces each merge field with the corresponding value from the source, line after line.
The use cases are numerous: commercial letters, address labels, badges, certificates, targeted newsletters. The time saving is exponential when you have more than ten recipients.
The workflow is broken down into five steps: 1) prepare the data source, 2) write the template, 3) insert the fields, 4) preview and filter, 5) finalize the delivery (print or email).
2. Excel Data Source
Word can use many formats as a source: Excel spreadsheet, Outlook list, Access database, CSV file, or even an existing Word list. Excel remains the most common choice because it is accessible to everyone.
To prepare your Excel file: each column represents a field (Last Name, First Name, City, etc.), the first line contains the headers, and there must be no empty lines between the data. Avoid merged cells.
Important: Close the Excel workbook before you associate it in Word. If the file is open, Word will not be able to read it. Keep the file path, you will need it when connecting.
3. Merge Fields and Insertion
Merge fields are invisible tags that Word replaces during generation. The main ones are: “First name”, “Last name”, “Address”, but also conditional or calculation fields.
To insert a field, position the cursor where you want then click Insert Merge Field in the Mail Merge tab. You can also enter “Field_Name” directly with chevron quotes, but the graphical method is more secure.
The mail merge assistant guides you step by step: it asks you for the type of document (mail, e-mail, envelopes, etc.), then the source, then the fields. You can restart the wizard at any time from the tab.
4. Preview and send
Before printing everything, use the preview to check the records one by one. The ◀ ▶ buttons allow you to navigate through the data source. Check for line breaks, long text and empty fields.
You can filter records (for example, only contacts from Paris) or exclude duplicates. The print preview offers a rendering faithful to the final result.
Finalizing offers three options: Print Documents (directly or in ranges), Edit Individual Documents (creates a single file with all results), or Send Email (requires Outlook association).
🔎 Concrete example — Real-world example — Personalized commercial mail
// Expected structure in Excel:
// Column A: First Name | B: Last Name | C: Company | D: Offer | E: City
// In Word, after connecting the source:
// «FirstName» «LastName»
// «Company»
// «City»
// Dear «FirstName»,
// We are pleased to present
// the «Offer» plan tailored for «Company».
// Best regards,
// The Sales TeamCreate a personalized offer letter for 200 prospects from an Excel list.
Verify that Excel headers match the inserted fields exactly
Use the filter to only send to targeted cities
Send by email if an 'Email' column exists in the source
Use conditional fields to adapt the text according to the offer
Section vocabulary
- Direct mail
- Word functionality that automatically generates personalized documents from a template and data source
Simple example: Imane applies “Mail Merge” in her professional documents.
What it is not: treat “Mail Merge” as a detail with no impact on the document.
Reflex: Does this choice make the document clearer and more reliable?
- Merge Field
- Placeholder tag (e.g. “Name”) in the template document, replaced by the source data during finalization
Simple example: Imane applies “Fusion Field” in her professional documents.
What it is not: treat “Merge Field” as a detail with no impact on the document.
Reflex: Does this choice make the document clearer and more reliable?
- Data source
- File containing the information to inject (Excel, CSV, Outlook list, Access database)
Simple example: Imane applies “Data Source” in her professional documents.
What it is not: Treat “Data Source” as a detail with no impact on the document.
Reflex: Does this choice make the document clearer and more reliable?
- Mail Merge Wizard
- Step-by-step guided tool in the Mail Merge tab makes it easy to fully configure mail merge
Simple example: Imane applies “Mailing Assistant” in her professional documents.
What it is not: treat “Mail Merge Wizard” as a detail with no impact on the document.
Reflex: Does this choice make the document clearer and more reliable?
In practice — Create event badge badges
- Prepare an Excel file with the columns: First name, Last name, Company, Position, Table
- Open a new Word document and launch the Mail Merge Assistant
- Choose 'Labels' as document type
- Connect the Excel file (by closing it first!)
- Insert merge fields on template label
- Preview multiple badges and check alignment
- Print all badges
Script ready to say — Direct mail & mailing (25 s)
“Master complete mail merge: connect a data source, insert merge fields, preview, filter and generate personalized documents or emails. Concretely, I check this point before distributing the document: mail merge merges a word model with a data source to create mass personalized documents. »
Short wording, to be adapted to the recipient and the context of the document.
Copy and paste template — “Direct mail & mailing” checklist
CHECKLIST — Direct mail & mailing
1. Mail Merge merges a Word template with a data source to create mass personalized documents.
2. Excel is the most common source: headers in line 1, no merged cells, file closed before connection.
3. The Mail Merge Wizard guides the 5 steps: type, source, fields, preview, finalization.
4. Three output modes: print, individual edit or email via Outlook.
EXPECTED RESULT: A set of printable badge labels, each personalized with each participant's data.Express version
Apply only the essentials and the first key point, then check the rendering in a short document.
Remote
Share a PDF and check fonts, margins and pagination before sending.
As a team
Lock in the common model and document choices to keep colleagues consistent.
Printed version
Check pagination, headers and contrast before printing.
✓ Best practices
- Always prepare your Excel source before launching the mail merge: clear headers, no merged cells, no blank lines.
- Close the source Excel file before connecting it into Word, otherwise the connection will fail silently.
- Use the preview carefully: check for long text, line breaks, and potentially empty fields.
- For email sending, set Outlook as the default client and test with a single recipient before mass sending.
✗ Common pitfalls
- Forgetting to close the Excel file: Word will not display an error, it will simply offer to create a new list.
- Column names with spaces or special characters: Word truncates or reformats them (eg: 'First name' becomes 'First name').
- Too much text in a field: the text overflows from the final document, especially on the labels.
- The Mail Merge Wizard closes and is not easily restartable: remember to complete it completely each session.
Key takeaways
- Mail Merge merges a Word template with a data source to create mass personalized documents.
- Excel is the most common source: headers in line 1, no merged cells, file closed before connection.
- The Mail Merge Wizard guides the 5 steps: type, source, fields, preview, finalization.
- Three output modes: print, individual edit or email via Outlook.
48 hour challenge — apply tomorrow
Resume creating event badge badges on a real document from Imane's SME: Prepare an Excel file with the columns: First name, Last name, Company, Function, Table. Time it for 20 minutes and note what has changed.
- I can explain and apply: Mail merge merges a Word template with a data source to create mass personalized documents.
- I can explain and apply: Excel is the most common source: headers in line 1, no merged cells, file closed before connection.
- I can explain and apply: The Mail Merge Assistant guides the 5 steps: type, source, fields, preview, finalization.
Frequently asked questions
Can I edit the Excel source after launching the mail merge?
Yes, but you have to close Word, modify Excel, then restart Word. The connection will be made automatically to the last source used.
How to manage empty fields (e.g. no company)?
Use an IF conditional field to display alternative text or nothing at all when the field is empty.
Does mail merge work without Outlook?
For sending by e-mail, Outlook is required. For printing or editing documents, no other applications are required.
How to save the model for reuse?
Save the document as .dotx (Word template). The merge fields and connection to the source will be preserved.
What step is required before connecting an Excel file as a mail merge source?