 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Mailmerge and Fax / February 2005How 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 Look into AutoText and / or mailmerge (catalog merge)  SignatureCharles 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. > I've created a document from a template (.dot) and need to add more > 'copies' [quoted text clipped - 12 lines] > 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. > Look into AutoText and / or mailmerge (catalog merge) > > I've created a document from a template (.dot) and need to add more [quoted text clipped - 13 lines] > > 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/cindymeister/MergFram.htm SignaturePlease 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 > 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 [quoted text clipped - 26 lines] >> > Thanks, >> > jim cant |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.