I have an excel spreadsheet with 130 rows of information. I need to create 130 PDF forms (1 form for each row in the spreadsheet). Is there a way to export from excel into a PDF form? I am currently using the Forms Center in Acrobat Pro. If not, can I export from any tool (Access, a SharePoint list, etc) into a PDF form?
This might help:
Note PC version the look will be different the basic layout should be similar.
Note: the column or row headers in the Excel file and the Field names in The PDF has to be indentical.
Example Last, First, MI, Address, Address2, City, State, Zip, Phone, Fax, Cell, Email, Website; must be same number of fields and same exact, name spelling Or elese the infor mation will not be picked up.
There is no automatic mail merge type of feature that will generate a PDF for each record in a spreadsheet. The method Phillip mentioned will allow you to manually import a single row of data, but you'll have to export to a tab-delimited text file. As mentioned, the first row must be the field names and the subsequent rows the corresponding records.