Copy link to clipboard
Copied
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!
Copy link to clipboard
Copied
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.
Copy link to clipboard
Copied
sorry, the error I am getting is "SOME DATA IN THE TEXT FILE WAS NOT IMPORTED SUCCESSFULLY".
Copy link to clipboard
Copied
OK, but was the data you're interested in imported correctly?
Copy link to clipboard
Copied
I have never done .txt to a form field in Acrobat so i do not think i am setting up the import correctly.
Copy link to clipboard
Copied
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.