🇮🇩 ID | 🇬🇧 EN

Section 15: Mail Merge (Mass Mailing)

⏳ Training Duration: 45 Minutes

🎯 Level: Intermediate

🧠 Method: Theory + Practice

📦 Material Format: Interactive (offline/online)

📌 Requirements: Basic understanding of Microsoft Word

🎯 Objective: Participants are able to create mass documents (Mail Merge) using data from Excel or other sources.

Mail Merge is a feature in Microsoft Word that allows us to create multiple documents at once—such as letters, certificates, or invitations—with different content for each recipient.

With Mail Merge, we only need to prepare one template document and one recipient data source. Word will then automatically adjust the document content based on each recipient’s data.

This feature is very helpful for saving time, especially when working with a large number of documents such as official letters, training certificates, or event invitations.

To ensure a smooth process, make sure the recipient data is well organized—whether using Excel, CSV, or a list created directly in Word (Address List). Use clear column names (headers) and avoid empty data in important fields.

Basic Steps of Mail Merge

  1. Prepare a Word document as the letter template.
  2. Open the Mailings tab and click Select Recipients > Use an Existing List.
  3. Select the recipient data source, such as an Excel file, CSV, or a list created directly in Word (Address List).
  4. Use Insert Merge Field to insert data such as Name, Address, etc.
  5. Click Finish & Merge to print or save all merged documents.
Note:
In this example, recipient data is created directly using the Type a New List feature in Word, which is automatically saved as a database file (.mdb). However, you can also use Excel or CSV files as your data source.
Mail Merge template document in Word
Prepare a template document in Word that will be used as the base for mass mailing.
Mailings tab in Word
Open the Mailings tab to access all Mail Merge features.
Creating recipient data in database
Click Type a new list then choose Create ... to create recipient data.
Creating recipient fields in database
Click Delete all fields, then Add to create new database fields.
Creating recipient data list in Word
Enter the data into the database and it is ready to be used in the Word document.
Saving recipient data list in Word
Data will be automatically saved as a .mdb database file by Word and can be reused for other Mail Merge tasks.
Inserting Mail Merge fields
Use Insert Merge Field to add data such as name or institution into the letter content.
Mail Merge preview result
Use the Preview Results button to see the document before printing.
Finishing and printing Mail Merge
Click Finish & Merge then select Print Documents to print mass letters.
Example of Mail Merge output
Each recipient will receive a certificate with data automatically filled based on the database.
Excel data must be well structured: the first row as headers (Name, Address, etc.) and no empty cells in important columns.
💡 Workplace Tip:
Mail Merge is commonly used for creating training certificates, mass invitation letters, and even employee payslips. By mastering this feature, tasks that usually take hours can be completed in just minutes.

📌 Conclusion

Mail Merge is a powerful feature in Microsoft Word for creating multiple documents with different content automatically.

  • Document template is used as the base layout for letters or certificates
  • Data source (Excel, CSV, or Address List) contains recipient information
  • Merge Fields connect the data into the document content

By mastering Mail Merge, we can complete tasks much faster, more efficiently, and with fewer errors.

This feature is widely used in the workplace, especially for mass letters, training certificates, official invitations, and other administrative documents.

💡 One template, hundreds of documents completed in minutes.

📝 Practice:

  1. Create an Excel file with columns: Name, Institution, Address.
  2. Create an invitation letter in Word with automatic greeting and content from Excel data.
  3. Export to PDF using Finish & Merge > Print Documents.