MailMerge

Print Certificates Using Word with a list of employee names that are stored in Excel
During the last Excel Executive training that I have conducted, there is a question that was raised by a participant. “How can
she print certificates for hundreds of her staff by using word, and she already has their details in Excel.

Here is the certificate in Word format:

MailMerge using Excel Tutorial

 

Date in Excel Format:

 

MailMerge using Excel Tutorial


The steps are as follows:

1.  In Word, on the Mailings tab, in the Start Mail Merge group, click Select Recipients, and choose Use Existing List…

 
MailMerge using Excel Tutorial
 
 
 

2.  In the Select Data Source dialog box, locate the Excel file.

 

MailMerge using Excel Tutorial

 

3. For Excel, you can select data from any worksheet or named range within a workbook.

 

 MailMerge using Excel Tutorial

 

4. In Word, on the Mailings tab, in the Write & Insert Fields group, click the first field to be inserted: Name. Repeat the same steps for the remaining fields.

 

MailMerge using Excel Tutorial

 

5. In Word, on the Mailings tab, in the Preview Results group, click Preview Results to see the result.

 

MailMerge using Excel Tutorial

 

6. In Word, on the Mailings tab, in the Finish group, click Finish & Merge, then choose Print Documents….

 

MailMerge using Excel Tutorial

7. In the Merge to Printer dialog box, choose the Print records option that you need and click OK.

MailMerge using Excel Tutorial

 

By Bee Bee Ong  | Google

 

Cempaka Technology Sdn Bhd

Pusat Latihan Komputer Cempaka
~Your HRDC Premiere Training Provider~
64-2, Jalan Puteri 2/2, Bandar Puteri Puchong, 47100 Puchong Selangor, Malaysia. Tel: 603-80684461
1-28, Jalan PM4, Plaza Mahkota, 75000 Melaka. Tel: 606-2835955
Instant SSL