Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to add additional copies of template to document
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Moving templates to other computer | Microsoft Word Help | |||
Autotext exclusive to a new template | Microsoft Word Help | |||
Bring custom toolbars with templates | Page Layout | |||
How do I access a created template from letter wizard | Microsoft Word Help | |||
Template Pull-down menus do not load with Template | Microsoft Word Help |