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

Look into AutoText and / or mailmerge (catalog merge)
--

Charles Kenyon

Word New User FAQ & Web Directory: http://addbalance.com/word

Intermediate User's Guide to Microsoft Word (supplemented version of
Microsoft's Legal Users' Guide) http://addbalance.com/usersguide

See also the MVP FAQ: http://www.mvps.org/word which is awesome!
--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.

"Jim Cant" wrote in message
...
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

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.
"Charles Kenyon" wrote in
message ...
Look into AutoText and / or mailmerge (catalog merge)
--

Charles Kenyon

Word New User FAQ & Web Directory: http://addbalance.com/word

Intermediate User's Guide to Microsoft Word (supplemented version of
Microsoft's Legal Users' Guide) http://addbalance.com/usersguide

See also the MVP FAQ: http://www.mvps.org/word which is awesome!
--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.

"Jim Cant" wrote in message
...
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

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/cindy...r/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
"Jim Cant" wrote in message
...
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.
"Charles Kenyon" wrote in
message ...
Look into AutoText and / or mailmerge (catalog merge)
--

Charles Kenyon

Word New User FAQ & Web Directory: http://addbalance.com/word

Intermediate User's Guide to Microsoft Word (supplemented version of
Microsoft's Legal Users' Guide) http://addbalance.com/usersguide

See also the MVP FAQ: http://www.mvps.org/word which is awesome!
--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.

"Jim Cant" wrote in message
...
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