VDP from Excel to a specific field in a PDF

[Ren Sukhram]

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]

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.

[Ren Sukhram]

sorry, the error I am getting is "SOME DATA IN THE TEXT FILE WAS NOT IMPORTED SUCCESSFULLY".

[try67]

OK, but was the data you're interested in imported correctly?

[Ren Sukhram]

I have never done .txt to a form field in Acrobat so i do not think i am setting up the import correctly.

[try67]

You can export to that format to see the structure, but all there is to it is it needs to have two (tab-delimited) rows, the first one with the field names and the second one with their values.