How to Easily Automate Importing of Names to its Own Certificate and Print Using Only Excel and Word
Skill will bring sucess. "If the ax is dull and its edge unsharpened, more strength is needed, but skill will bring success." (Ecc. 10:10) And here's a warning, "By your great skill in trading you have increased your wealth, and because of your wealth your heart has grown proud." Eze. 28:5 (NIV)
Let's Say
You have 900 people attending your event and each needs to receive a printed certificate with their names on it. Are you willing to type and/or copy-paste in 900 names to your layout? Yes, maybe, for some, but that takes time – and effort too! Desperately, we hope to comfort them enough to let them leave with a preprinted certificate. Though gets the job done easily, one eager guy at home must have ruined his precious certificate with his penmanship.
You have MS Word and Excel? You have all the tools you need! Here’s how to easily input names to their own certificate and print! Great help to event coordinators, and teachers!
Here's What You Need To Do
You design your certificate in MS Word (or save your work from your software as PNG and just paste it there).
Prepare the list of names of all participants in MS Excel. We’ll take only 9 for example.
Save your MS Word & Excel files in one folder for quick access.
Back to your certificate, go to “Mailings” - “Select Recipients” - “Use an Existing List...”
Open the Excel file containing your list of attendees.
Select the sheet that contains the list (for this demo, Sheet 1). You might as well click “Edit Recipient List” to check the import.
Click “Insert Merge Field” and start by inserting in the name fields to their proper places in the certificate.
You can choose to format your name entry - set the color, font, size, & style. And don’t forget to add space, or comma for the suffixes.
You can check your work with “Preview Results”.
Satisfied with the results, hit “Finish & Merge” – “Edit Individual Documents...”
Few more choices, and you go.
Word automatically creates a certificate for each participant in another Word file. You can save it as another file, print, and you’re done.
Here’s what it would look like when done.
Here’s the result.
What Do You Think?
Receiving a preprinted certificate might be dull. Doing this costs only a little of your time. Are you willing to end the conventional?
You have 900 people attending your event and each needs to receive a printed certificate with their names on it. Are you willing to type and/or copy-paste in 900 names to your layout? Yes, maybe, for some, but that takes time – and effort too! Desperately, we hope to comfort them enough to let them leave with a preprinted certificate. Though gets the job done easily, one eager guy at home must have ruined his precious certificate with his penmanship.
You have MS Word and Excel? You have all the tools you need! Here’s how to easily input names to their own certificate and print! Great help to event coordinators, and teachers!
Let the wise listen and add to their learning, and let the discerning get guidance. Prov. 1:5 (NIV)
Here's What You Need To Do
You design your certificate in MS Word (or save your work from your software as PNG and just paste it there).
Prepare the list of names of all participants in MS Excel. We’ll take only 9 for example.
Save your MS Word & Excel files in one folder for quick access.
Back to your certificate, go to “Mailings” - “Select Recipients” - “Use an Existing List...”
Open the Excel file containing your list of attendees.
Select the sheet that contains the list (for this demo, Sheet 1). You might as well click “Edit Recipient List” to check the import.
Click “Insert Merge Field” and start by inserting in the name fields to their proper places in the certificate.
You can choose to format your name entry - set the color, font, size, & style. And don’t forget to add space, or comma for the suffixes.
You can check your work with “Preview Results”.
Satisfied with the results, hit “Finish & Merge” – “Edit Individual Documents...”
Few more choices, and you go.
Word automatically creates a certificate for each participant in another Word file. You can save it as another file, print, and you’re done.
Here’s what it would look like when done.
Here’s the result.
What Do You Think?
For people may labor with wisdom, knowledge and skill, and then they must leave all they own to others who have not toiled for it. This too is meaningless and a great misfortune. Ecc. 2:21 (NIV)
Receiving a preprinted certificate might be dull. Doing this costs only a little of your time. Are you willing to end the conventional?
