How to use mail merge to print multiple certificate

Microsoft World mail merge wizard is very useful to print multiple names from a data source in ease of use, yet neglected by many newbie’s in MS Word because they don’t familiar to use it. For instance, to print a certificate with different names, with the help of mail merge wizard, no need to change each name or perhaps to create one by one certificate for its name to be printed rather, record first the list of names in a data source, for example in Excel, Access, etc. and link it to enable to print simultaneously based on the sequence of names you typed.

To do so, here are the samples step by step tutorial in how to use mail merge wizard.

Put the field name Name as a column and save it mailMerge, later on we are going to link it.

Now, back to MS Word Document and type the following. CERTIFICATE OF ATTENDANCE IS PRESENTED TO. The output looks like.

To link from our data source, we need to select Mailings Tab, select Start Mail Merge, and finally select Step by Step Mail Merge Wizard… in your right corner it shows.

 We have an option for what type of document are you working on. Let the default option Letters. In steps 1 to 6 we need to start our document, so next to step 3.

Now, we need to browse our files as what we created previously. Select browse and locate your files in the directory where you saved.

When you noticed, we had three Sheets, shows where our records are created, select Sheet1$ because we create our record in Sheet 1. Let’s continue to step 4.

In ribbon area, select Insert Merge Field, the Name appear when you select it, that’s name of your field name or column name in your Excel.

Noticed <<Name>> appears on your document to ensure you’ve already linked to your data source. Then continue to step 5. In arrow << Recipient: 1 >> determines the number of records in a list. Finally, step 6, mail merge is ready for printing.