Mobile app version of vmapp.org
Login or Join
Nickens508

: How to make 150+ certificates, each with a different name I have a "Certificate of Recognition" PSD file with a blank line for the name portion. Is there a way to input all the participants'

@Nickens508

Posted in: #AdobeIndesign #AdobePhotoshop #DataMerge #HowTo

I have a "Certificate of Recognition" PSD file with a blank line for the name portion. Is there a way to input all the participants' names without duplicating a certificate for each person individually?

10.02% popularity Vote Up Vote Down


Login to follow query

More posts by @Nickens508

2 Comments

Sorted by latest first Latest Oldest Best

 

@Si6392903

The answer depends on what other software you have.

You could do that in Indesign as Lucian mention or you could do that using Word pulling the names from Excel, or can be done in Corel Draw.

Google then your specific tutorial using this words:


Mail Merge Word Excel
Variable Data Word Excel


And you will get for example this:
support.office.com/en-us/article/Mail-merge-using-an-Excel-spreadsheet-858c7d7f-5cc0-4ba1-9a7b-0a948fa3d7d3
Change the name of the aplication depending on what you have. You can use Free Software like Open Office too.

10% popularity Vote Up Vote Down


 

@Ann6370331

Use InDesign for this. Link the PSD in InDesign as a background image, and overlay the names from a CSV list, which should be typed in the format below. Then use Data Merge to set up importing the names and use a paragraph style to format these over your PSD background.

name
Anton
Gabriele
Carla
...

10% popularity Vote Up Vote Down


Back to top | Use Dark Theme