DIGITAL CERTIFICATE

---

🎓 How to Add Names to a Digital Certificate Using Microsoft Word

🪄 What You Need

1. A certificate template in Word (or an image of the certificate).

2. A list of names in Excel.

---

🧩 Step 1: Prepare Your Excel List

1. Open Excel.

2. In Column A, type a header — for example:

   Name
   

3. Below it, list all student names:

   Name
   Ali Bin Abu
   Siti Nuraini
   Lim Wei Jun
   Aisyah Zainal
   

4. Save this file (e.g. CertificateNames.xlsx) and close Excel.

---

🧾 Step 2: Prepare Your Certificate Template in Word

1. Open Microsoft Word.

2. Go to Layout → Orientation → Landscape (usually certificates are horizontal).

3. Insert your certificate background:

   • Go to Insert → Pictures → This Device

   • Choose your certificate background image (or save your PDF as a picture first).

   • Right-click the image → Wrap Text → Behind Text

   • Adjust to fit the whole page.

4. Now, click where the name should appear, and type something like:

   <<Name>>
   

   (You’ll replace this with the real merge field later.)

---

🔗 Step 3: Link Excel to Word (Mail Merge)

1. In Word, go to:
   Mailings → Start Mail Merge → Letters

2. Then click:
   Select Recipients → Use an Existing List...

3. Browse and select your Excel file (CertificateNames.xlsx).

4. Choose the correct sheet and confirm.

---

✨ Step 4: Insert the Name Field

1. Place your cursor where the name should appear.

2. Go to Mailings → Insert Merge Field → Name

3. The placeholder <<Name>> will appear.

---

🔍 Step 5: Preview and Finish

1. Click Preview Results in the Mailings tab.
   → You’ll see the first student’s name appear on the certificate.

2. Use the arrows ◀ ▶ to preview all certificates.

3. When ready:

   • Click Finish & Merge → Edit Individual Documents

   • Choose All → OK

Word will generate a new file with all certificates (one per student).

---

💾 Step 6: Save or Export to PDF

Finally:

• Go to File → Save As → PDF

• You’ll have a set of personalized digital certificates 🎉

---

Would you like me to prepare a ready-to-use sample (Word + Excel template) that you can just fill with your students’ names?
I can generate and send it to you here.

Excellent question, Su 🌟 — that’s a very practical enhancement for teacher use (especially for certificates needing name + IC number).

Let’s improve Step 4 to include both fields clearly.

---

🧩 Step 4: Insert the Name and IC Number Fields

✅ Step 4.1 — Update your Excel list

Before anything, make sure your Excel file has two columns:

Name	IC
Ali Bin Abu	030512-10-5678
Siti Nuraini	041020-05-2233
Lim Wei Jun	030807-14-1122
Aisyah Zainal	040301-01-4455

Save and close your Excel file.

---

✅ Step 4.2 — Insert both fields in Word

1. In your Word certificate file, click on the Mailings tab.

2. Put your cursor where the name should appear.

3. Click Insert Merge Field → Name.

   • You’ll see «Name» appear.

4. Press Enter (to go to the next line below).

5. Click Insert Merge Field → IC.

   • You’ll see «IC» appear below the name.

So it looks like this:

«Name»
«IC»

---

🪄 Optional Formatting Tips

To make it look professional:

• Center align the text (Ctrl + E).

• Change the font to something elegant like Times New Roman, Garamond, or Segoe Script.

• Make the name bigger (e.g., font size 28–36).

• Make the IC smaller (e.g., font size 18).

• Add bold to the name only if needed.

Example visual layout:

         «Name»
         «IC»

---

✅ Step 4.3 — Preview Results

1. Go to Mailings → Preview Results.

2. You’ll now see each student’s name and IC number correctly displayed on the certificate.

3. Adjust spacing or size if needed.

---

Would you like me to create a sample Word + Excel template (with placeholders for Name & IC) that you can download and test right away?
I can generate one for you instantly.