In InDesign the feature you want is called Data Merge, and I think the Help topic does a pretty good job of explaining how to use it.
Yes this seems exactly what i need! Thanks for the Info
Yes, this works very well but watch what InDesign is up to. It adds a page for each certificate. I was practicing this for someone else to do then sent the files and they had a practice before the final run but it would not print. Then someone noticed the thing had over 5000 pages. Everytime we did a merge it add more pages.
RIch, it sounds like you are doing something wrong, unless you have that many records. You should not be getting more than one page per record in a job like this.
You have the option, alos of specifying a range of records to merge so you can break itinto more manageable chunks, or specify a range to print. That said, if you really have thousands of copies to print, Data Merge may not be the best solution. A real VDP module on the printer that can take a single page to RIP, then add the custom information on the fly from your database is a lot more efficient and would probably be cost effective if you do a lot of this kind of work (or you could send it out to someone who does).