Skip to main content
dominicj98593632
dominicj98593632
Participant
October 6, 2017
Answered

Mail Merge to multiple unique PDFs with unique names from one template

  • October 6, 2017
  • 1 reply
  • 6700 views

I can't seem to find any info on this scenario which I thought would be something a ton of people use. I have a template. I want to use a CSV file to export the template as multiple PDFs. This is because each PDF output will have a separate address phone number and be shared with an office that doesnt need any of the either info that I am importing from the csv. I don't want them all to "merge" into one PDF.

It would also be nice to be able to have each of the first cells used in the name. so it ends up being "template_brampton.pdf" "template_toronto.pdf" etc.

Thoughts on how to do this?

This topic has been closed for replies.
Correct answer Colin Flashman

Is this what you're after? It's a script that data merges to single records with unique names based on database entries. Creates PDFs or INDDs.

https://colecandoo.com/2015/09/04/data-merge-from-indesign-to-unique-filenames-now-a-reality/

1 reply

Colin Flashman
Community Expert
Colin FlashmanCommunity ExpertCorrect answer
Community Expert
October 7, 2017

Is this what you're after? It's a script that data merges to single records with unique names based on database entries. Creates PDFs or INDDs.

https://colecandoo.com/2015/09/04/data-merge-from-indesign-to-unique-filenames-now-a-reality/

If the answer wasn't in my post, perhaps it might be on my blog at colecandoo!
dominicj98593632
dominicj98593632Author
Participant
October 10, 2017

Yes that is nearly exactly what I was looking for!! Love it. Thank you so much. I think the only minor addition I think that would be very helpful would be to have the script also be able to grab the current file name and add the the additions to that. so that in my case it might end up being something like:

Test File-Thankyou-Large-Barrie.pdf

Test File-Thankyou-Large-Brampton.pdf

Test File-Thankyou-Large-London.pdf

In the above scenario the city name would be the only thing pulled from the excel doc. The rest are what the name of the original indesign file was. I think for now I'll find a program that can quickly rename then to add the file name back in before the unique variable that was pulled from the script. But if there is a modification to that script please let me know!!

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices