Results 1 to 6 of 6
  1. #1
    Lounger
    Join Date
    Nov 2004
    Posts
    46
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Multiple Merge Records in a document (Word 2000)

    I have a document with 3 sections.
    Section 1 I need a loop facility to add fields of names unknown numbers without changing some of the other field information entered information. I need to print one copy of of this section.
    Section 2 I need to print as many times as the first document has looped to each of the names and also with some of the field information that has not been changed.
    Section 3 I need to print as many times as a number generated from the looped number to each of the names also with some of the field information that has not been changed and also taking a field entered value and dividing it with a number generated from the number looped.

    Is this possible in Word? and any ideas how to do this

    Look forward to hearing from anyone that can help.

    Thanks and regards

  2. #2
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: Multiple Merge Records in a document (Word 20

    First, buy a bottle of ibuprofen. <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

    But seriously, Word is not the best tool for working with variable numbers of printouts of different sections. Instead, Word would prefer that you generate multiple documents, and provides the mail merge feature for this. I don't use it much, but it does seem that you want to end up with three different documents (whether as sections in one document or as three files), all of which share a common data source (which, in merge-land, can be a Word document containing a table). Does that make sense, or is there a special reason for an "all-in-one" approach driven by macros?

  3. #3
    Lounger
    Join Date
    Nov 2004
    Posts
    46
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Re: Multiple Merge Records in a document (Word 20

    Hi
    Thanks for the reply

    There is a reason for generating the document as a single package. Past practice has shown that if this is not done there are sections not printed though laziness etc and it is essential that all are printed. At the moment what is produced is a single printed document but that does not fully meet the requirements since some of the information is not correct.
    It is also important because the 'record' information is not retained but the merged document is.
    I am considering the option of creating all the bits under the banner of a form but I'd prefer to try and modify what I have for the moment.

    As you may have guessed I don't just take ibuprofen but paracetamol and codine as well <img src=/S/brickwall.gif border=0 alt=brickwall width=25 height=15>

    Best regards
    Duncan

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 28 Times in 28 Posts

    Re: Multiple Merge Records in a document (Word 20

    Although you can do very clever things with mail merge, I think I would not use a merge for this, but construct the entire document in code, using AutoText entries and placeholders for text to be replaced. But it would be a lot of work.

  5. #5
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,613
    Thanks
    3
    Thanked 58 Times in 58 Posts

    Re: Multiple Merge Records in a document (Word 20

    You don't indicate what the data source for the merge is, so I presume it isn't in a database such as Microsoft Access. Word does have a .NextRecord field code that is used with label and catalog merges, but I don't think there is a way to reset it to the beginning of the data. I'm with Hans on this - doing the VBA to populate the document looks to be the only way, and it will be a good deal of work. We have done things like this using Automation from Access, and while it's quite tedious, you can do some very sophisticated document construction.
    Wendell

  6. #6
    Lounger
    Join Date
    Nov 2004
    Posts
    46
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Re: Multiple Merge Records in a document (Word 20

    At the moment I use the document solely with the mail merge facility and have tried to avoid having it interact with such as Access but I feel it may be getting too complex without extending beyond Word alone.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •