Microsoft Office · Intermediate level

Intermediate level · Module 1: Long Documents, Templates and Mail Merge · Lesson 3 of 3

Mail Merge for Letters and Certificates

Generate personalised letters, labels or certificates from a list of names in Excel.

In this lesson you will

  • Connect a Word document to an Excel list
  • Insert merge fields and preview results

Key concepts

data sourcemerge fieldpreviewmerge to new document/PDF

The lesson

Mail merge combines a Word document with a list — usually an Excel sheet — to produce one personalised copy for each row: certificates, invitation letters or payment notices.

The quality of the result depends on the data. Check the Excel list first: one header row, no blank rows, names spelled correctly and dates formatted consistently.

Insert merge fields where the personal details go, preview several records, then finish the merge to a new document or PDF. Always check a sample before printing hundreds of copies.

Step by step

  1. Clean the participant list in Excel.
  2. Start the mail merge and select the list.
  3. Insert merge fields into the certificate.
  4. Preview, finish and check a sample of certificates.
Step-by-step

Mail merge: 20 certificates in minutes

The full sequence from a participant list in Excel to checked, personalised certificates.

  1. Clean the list

    In Excel, keep one header row (FirstName, LastName, Course, Date), remove blank rows and check every spelling with the participants.

  2. Design the certificate

    In Word, create the certificate with placeholder text where names and course details will go.

  3. Connect the data

    Mailings > Select Recipients > Use an Existing List, then choose the Excel file and the sheet.

  4. Insert merge fields

    Replace the placeholders with Insert Merge Field: «FirstName» «LastName», «Course», «Date».

  5. Preview every record

    Preview Results and step through the records. Long names may need a smaller font size.

  6. Finish and check

    Finish & Merge > Edit Individual Documents, save as PDF and check three certificates against the list before printing.

Result

One correctly personalised certificate per participant, produced from the same template every time — and corrected in seconds if a name changes.

Practice activity

Produce personalised training certificates for 20 participants from an Excel list.

Expected result: Twenty correctly personalised certificates.

Check your understanding

  1. What two things does a mail merge combine?

    Show answer

    A main document (template) and a data source (list of records).

Taught live by an instructor — online or in person. Free course lessons are for self-study and do not lead to a certificate — see registration options.