VDP from Excel to a specific field in a PDF

Question

so we have a form where we have to merge from a spreadsheet to a specific field on a the document. The doc has easily 10+ fields but I want to ignore those fields. I tried to create a .txt and use the edit/form options but it gives me an error and I cannot find anything really explaing this function properly.

part two to this would be to have the form use only 20 records at a time due to the field size versus number of rows. If I could merge 20 records then save, then merge the next 20 then save, etc that would be ideal...

thank you for reading!

try67 · Answer

1. If the text file only contains the one field you want to import, that should work. You say there's an error, but don't let us know what it says. This is crucial to be able to help you with this issue...

2. This is called Mail Merge. It can be done using some versions of the Adobe PDFMaker plugin for Office, or using a script, like this (paid-for) tool I've created exactly for this purpose:

https://www.try67.com/tool/acrobat-mail-merge-and-email-pdf-files

Note it can create separate files (one for each row of data from the data file), or a single PDF file with all the pages from the original, duplicated for each record.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded