Skip to main content
Participant
October 18, 2022
Answered

Way to 'automatically' change text between pages

  • October 18, 2022
  • 2 replies
  • 267 views

So I have a certificate type thing that I need to duplicate, and put different names in. We're talking about ~80 names all in one excel file. Is there a way to automatically add each name to each page by using the spreadsheet or something else, just so I don't have to manually copy and paste every name?

This topic has been closed for replies.
Correct answer Kim Lien25403608m28x

A good opportunity to point Colin's website : https://colecandoo.com/

He works intensively with datamerge and you can find there valuable tips.

Loic

2 replies

Legend
October 18, 2022

Hello @Guilherme26667301vpge,

 

As @m1b stated, "it sounds like a good candidate for a data merge"

If you're going to need to export the merged pages separately look at the post below...

https://community.adobe.com/t5/indesign-discussions/how-datamerge-gt-export-as-individual-pdfs-gt-automatically-name-each-pdf-using-pdf-dynamic-fields/m-p/11634878#M405783

 

Regards,

Mike

Kim Lien25403608m28xCorrect answer
Participant
October 18, 2022

A good opportunity to point Colin's website : https://colecandoo.com/

He works intensively with datamerge and you can find there valuable tips.

Loic

m1b
Community Expert
Community Expert
October 18, 2022

Hi @Guilherme26667301vpge, it sounds like a good candidate for a data merge. Have a look at that, and also google tutorials, and I think you can solve your problem that way.

- Mark