These forums are now Read Only. If you have an Acrobat question, ask questions and get help from one of our experts.

How to Populate Fields in Acrobat X Pro

Forum Index > Forms: Acrobat > How to Populate Fields in Acrobat X Pro
2011-09-16 06:26:42
NoviceUser
Registered: Sep 16 2011
Posts: 1

Hi,
Trying to take about 35 names and addresses from an excel file and populate them into an Adobe letter that I have. I also want to be able to save each address as one file and print the form. Even if its easier to save it as a PDF package where I can print each letter with the address, that works too.
 
I have Adobe CS5 Web Premium for my software package that has Adobe X Pro and LiveCycle ES2 and Office 2010. I tried to create an XML file but its not working. I don't know much about javascript either:(
 
Any help would be GREATLY appreciated!
 
Thanks!

My Product Information:
Acrobat Pro 10.1, Windows
Top
2011-09-16 09:18:01
#1
thomp
Expert
Registered: Feb 15 2006
Posts: 4411
You have a few different options, however, they all require a bit of work. First, you'll need to create a form that is suitable for receiving the data. This usually means the fields are named a certain way. But in the case of a LiveCycle form it can mean structuring the form hierarchy a certain way and/or binding the fields to an XML template.

On the data side, the Excel data can be saved in a variety of formats: CSV, XML, tab delimited. All of these can be used in different ways to populate fields in a PDF form. For example, read the article on External File Data. This solution requires a bit of scripting. So another solution is to create a dynamic LiveCycle form where the entire first page is a repeated subform that represents one line of data from the XML file. Then the XML data saved out of Excel is imported directly to create as many pages as there are data lines.




Thom Parker
The source for PDF Scripting Info
www.pdfscripting.com
Very Important - How to Debug Your Script

Top
2011-09-17 02:49:45
#2
try67
Expert
Registered: Oct 30 2008
Posts: 2398
I have developed a mail-merge application that can produce multiple copies of a template PDF file based on an Excel spreadsheet, and name each file based on a certain name pattern that you define.
If you're interested, contact me by email.

- AcrobatUsers Community Expert - Contact me personally at try6767 [at] gmail [dot] com
Check out my custom-made scripts website: http://try67.blogspot.com

Top