How to add additional copies of template to document

[Jim Cant]

I've created a document from a template (.dot) and need to add more 'copies'
of the template to get additional 'pages' in the document.

I need to generate a collections of invoices from a result set of a database
query. Each invoice requires data from a variable number of records. I
can, in VBA, iterate through the records and when I detect that a new
invoice should start, I want to add a page break to the active document then
add another copy of the template to the current document receive the next
invoice's worth of data.

I appreciate your suggestions,
Thanks,
jim cant

 

[Charles Kenyon]

Look into AutoText and / or mailmerge (catalog merge)

 

[Jim Cant]

Thanks for the suggestions but they don't really answer the question. I
need to be able to start a new invoice (i.e. page) whenever I've finished
processing the current one. Each invoice can use a varying number of
records from the record set (each adds a row to a table) and I need to do
the looping myself to process the records. The built in mail merge(s)
doesn't allow this.
So my question remains. Stated somewhat differently, how can I 'flush' the
current completed invoice and move on to a new blank page (or document or
template) when I detect a new invoice in the input data?
Thanks again.

 

[Doug Robbins]

Why wouldn't you be using a report in the database?

See the "Multiple items per condition" item under the "Special merges"
section of fellow MVP Cindy Meister's website at

http://homepage.swissonline.ch/cindymeister/MergFram.htm

--
Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP