Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Merge and publish multiple records from OLE DB connection

_Scott_Jenks_
Level 1
Level 1
Hi,



I'm hoping someone can help me, I'm new to LiveCycle Designer. I'm using Adobe LiveCycle Designer 7.0, version 7, 0, 041126, 0 on a MicroSoft XP machine.



I've created a two page form and bound the data elements from an OLE DB data connection to an Oracle table. When I click the "PDF Preview" tab, I'm able to see the data has merged correctly.



When I publish the form the first row of data from the OLE DB merges correctly into the PDF file, but it's only the first record.



Question 1 - How can I get ALL of the records to merge into a single PDF when I publish the file?



Question 2 - I also need a way to merge all of the records into sepearate PDF files. Is this possible?
2 Replies
_Scott_Jenks_
Level 1
Level 1
Hello,



I've spent a whole day looking through the documentation on-line, forums, and google help trying to figure this out. Is this not possible or am I asking the question incorrectly? I'm trying to merge all of the records in a database into a single PDF file for printing. A single merged record work fine and I have the ability to dynamically move forward and backward throught the dataset; however, it still escapes me as to how to get *all of the records into a single PDF.



Any assistance is greatly appreciated!
_Scott_Jenks_
Level 1
Level 1
After a week of digging through forums, documentation and working with Adobe Support, it has become painfully evident that Adobe Pro 8 with LiveCycle Design can not do the mail merge function that I'm requesting; however, I've found a solution to Adobe's shortcoming. There is a third party product that is a plugin called MailMerge by Evermap. It cost around $149 and it's well worth the time and aggrevation! They have a lot of other plugins as well for basic functions that are missing out of the Adobe products.



www.evermap.com