• Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers
Exit Search
0

VDP from Excel to a specific field in a PDF

Contributor ,
Mar 07, 2023 Mar 07, 2023

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!

TOPICS
PDF forms

Views

748

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Mar 07, 2023 Mar 07, 2023

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.

 

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Contributor ,
Mar 08, 2023 Mar 08, 2023

Copy link to clipboard

Copied

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

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Mar 08, 2023 Mar 08, 2023

Copy link to clipboard

Copied

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

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Contributor ,
Mar 08, 2023 Mar 08, 2023

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.

 

 

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Mar 08, 2023 Mar 08, 2023

Copy link to clipboard

Copied

LATEST

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.

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines