How to watermark a PDF mulitple times with variable data

[Jono Houston]

Hi All

I have search for hours and hours online to find an application that will perform the following task. Can I ask if anyone on this forum has any ideas?


1. Take a multiple page PDF document

2. Take a list of names from an excel spreadsheet

3. Use these names to automaticlly create a batch of watermarked copies of the document (one name per document). It would be nice to be able to edit how the watermark appears – font, orientation, text colour etc.

4. Independently re-save each watermarked document to a folder with the person’s name in the filename.


To put this into context... I work in television production and when we print the scripts for our cast and crew we need to watermark them. Therefore I would like to find a system that will automatically watermark the script PDF with each of their names.

Hoping someone may be able to help or point me in the right direction.

Cheers, Jono

 

[MisterMe]

One obvious thing strategy comes to mind:

1. Copy the PDF page-by-page into a Word document.
2. Create your watermark as mail merge field on each page of the new Word document.
3. Complete the merge.

 

[Jono Houston]

The PDF on average is a 90 page file which is made it Final Draft.
The formatting just dosen't transfer to Word.

 

[MisterMe]

...
The formatting just dosen't transfer to Word.

That is nonsense.

 

[nastebu]

The PDF on average is a 90 page file which is made it Final Draft.
The formatting just dosen't transfer to Word.

MisterMe is probably right. There's instructions for converting to Word here: http://www.screenstyle.com/abfidr7.html

Even if you have to futz around with the formatting to get it right, you'll save time over trying a bunch of half-baked solutions with the pdf. (you've already spent "hours and hours") The mail merge thing *will* work and will create separate files for you, which in the end will save a lot of time.

 

[KJHaymarket]

Eight years later and I have the same question. Microsoft Adobe Acrobat has the plug-in to create a mail merge, but I cannot find where anything like that exists for Mac?

 

[HDFan]

https://community.adobe.com/t5/acrobat/mail-or-data-merge-acrobat-pro-on-mac/td-p/10356714

Expensive, $99.

 

[KJHaymarket]

I just saw your post HDFan. . . Thank you for the information. I have downloaded the Demo for this application, but I am not able to complete the install. I have emailed the developer to see if I am doing something wrong. Thanks again!

 

[KJHaymarket]

Update and Thank You!
I have been able to successfully mail merge my excel data onto PDF documents via the following product.

Acrobat -- Mail Merge and Email PDF Files

Direct purchase using PayPal ($99 per license)! Another new and powerful tool to make your PDF experience easier and more efficient. Thi...

try67.blogspot.com

Shoutout to HDFan for leading me to this product. . . yes, it is $99, but it will be worth the cost.