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:

Excel Tutorial using MailMerge Training Melaka Puchong Selangor Malaysia

 

Date in Excel Format:

 

Excel Tutorial using MailMerge Training Melaka Puchong Selangor Malaysia


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…

 
Excel Tutorial using MailMerge Training Melaka Puchong Selangor Malaysia
 
 
 

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

 

Excel Tutorial using MailMerge Training Melaka Puchong Selangor Malaysia

 

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

 

 Excel Tutorial using MailMerge Training Melaka Puchong Selangor Malaysia

 

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.

 

Excel Tutorial using MailMerge Training Melaka Puchong Selangor Malaysia

 

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

 

Excel Tutorial using MailMerge Training Melaka Puchong Selangor Malaysia

 

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

 

Excel Tutorial using MailMerge Training Melaka Puchong Selangor Malaysia

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

Excel Tutorial using MailMerge Training Melaka Puchong Selangor Malaysia

 

By Bee Bee Ong 

 

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