Ok this is a macro I've inherited:

This macro, based on fields in a database file, selects different templates
according to the data. A template is opened as a new document and data fields
populated then saved as a new document. This macro creates a new document for
each record in the database, 500 records = 500 documents.

What I would like it to do:

I'd like the macro to create one document instead of the multiple it creates
now. So 500 records = 1 document with 500 pages. Again each page would be
based on the template selected by the data for that record.

This sounds simple to me but I have not been able to arrive at a solution.
Your input will be greatly appreciated.