Results 1 to 5 of 5
  1. #1
    New Lounger
    Join Date
    Sep 2017
    Posts
    3
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Repeating Lists in a Catalogue/Directory Mail Merge

    Hello everyone,

    I am new to this forum and just discovered Macropod's Catalogue/Directory Mail Merge Tutorial. Great work, Macropod!

    I read through the tutorial but could not find a solution to the problem that I'm facing. I was hoping that someone on the boards can help me out.

    Is it possible to repeat fields in a catalogue/directory mail merge? For example, if I have 4 records with the same key (State of CA), would I be able to output the data in the following format?

    San Francisco
    Los Angeles
    Sacramento
    San Diego

    San Francisco
    Los Angeles
    Sacramento
    San Diego

    With my limited experience, I tried to add an additional field to the code and the mail merge resulted in the following:

    San Francisco
    San Francisco
    Los Angeles
    Los Angeles
    Sacramento
    Sacramento
    San Diego
    San Diego


    Thanks for the help!

  2. #2
    Super Moderator macropod's Avatar
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    5,257
    Thanks
    2
    Thanked 478 Times in 393 Posts
    It's not apparent from your post why you'd be using a catalog/directory merge, since you don't appear to be grouping the data by city.
    Cheers,

    Paul Edstein
    [MS MVP - Word]

  3. #3
    New Lounger
    Join Date
    Sep 2017
    Posts
    3
    Thanks
    1
    Thanked 0 Times in 0 Posts
    Sorry about that. I am still very new to this and I oversimplified the problem. I am still trying to learn more about this process that I may be doing completely incorrectly.

    Here's my second attempt in trying to explain:

    Imagine if I was creating state specific reports with the major cities in every state and wanted to separate tables of unrelated data by city in each state (e.g. pets, health care provider).

    Ideally, two separate tables (pets and musical preference) would appear in the merge for each state report.

    Example:

    State: California

    Pets
    City Dogs Cats Birds Rabbits Hamsters
    San Francisco 9021 4684 6032 4133 1581
    Los Angeles 4414 4514 1601 7870 7147
    Sacramento 7479 2825 8018 7373 2950
    San Diego 6039 2558 7318 1481 2295

    Music
    City Jazz Rock Punk Country Heavy Metal
    San Francisco 1184 6407 3626 8252 5218
    Los Angeles 8634 4654 4035 9449 1472
    Sacramento 9430 9527 9474 6545 5274
    San Diego 9384 9540 8489 9713 7631

    Instead the tables were mixed together with the data for San Francisco Pets followed immediately by the row of data for San Francisco musical preference and so forth.

    Am I making things more complicated than they should be? If so, can you please point me in the right direction? Thank you in advance for any assistance that you can provide.

  4. #4
    Super Moderator macropod's Avatar
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    5,257
    Thanks
    2
    Thanked 478 Times in 393 Posts
    I suspect you'll need to do this using an ordinary Letter merge and separate DATABASE fields for your pet/music tables, plus a macro to drive the process. Without access to the datasource, however, it's impossible to know. An example of using a DATABASE field in a macro-driven mailmerge can be found at: http://answers.microsoft.com/en-us/o...1-1996c14dca5d
    The DATABASE field can even be used without recourse to a mailmerge. An example of such usage can be found at: http://www.msofficeforums.com/mail-m...html#post67097
    Cheers,

    Paul Edstein
    [MS MVP - Word]

  5. The Following User Says Thank You to macropod For This Useful Post:

    pa5cal (2017-09-13)

  6. #5
    New Lounger
    Join Date
    Sep 2017
    Posts
    3
    Thanks
    1
    Thanked 0 Times in 0 Posts
    Thank you, Paul! I'll check out the resources.

Posting Permissions

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