locked
Mail Merge Directory Page Break on Change in Data Source Field Value RRS feed

  • Question

  • Hi.  I am going to practically beg for help here...  I have researched to the best of my ability to get this to work and am quite frankly amazed that as long as office has been around, why microsoft has not built this functionality into their interface...  <off my soapbox>

    I have a data source that I am using in mail merge.  The main document is set up in table format to keep the data formatted nicely and I merge the data source data into the main document as a Directory document .  There are additional fields in the data soource but the important ones are listed below.  I need my directory to page break each time the the resident district code changes.  In the end all the records for 63100 will be on one page and 63200 will be on its own page and so forth.  Is there a way to do this in mail merge?

    <Resident Code>   <LastName>, <FirstName>  

        63100                  Smith, John

        63100                   Doe, Jane

        63200                   Billy, Bob

        82100                   Billy, Goat

     

    Monday, October 17, 2011 5:31 PM

Answers

All replies

  • Hi Janellc,

    You can indeed use Word's Catalogue/Directory Mailmerge facility for this (the terminology depends on the Word version). To see how to do so with any mailmerge data source supported by Word, check out my Microsoft Word Catalogue/Directory Mailmerge Tutorial at:
    http://lounge.windowssecrets.com/index.php?showtopic=731107
    or
    http://www.gmayor.com/Zips/Catalogue%20Mailmerge.zip
    Do read the tutorial before trying to use the mailmerge document included with it.


    Cheers
    Paul Edstein
    [MS MVP - Word]
    • Marked as answer by Max Meng Thursday, October 27, 2011 6:12 AM
    Tuesday, October 18, 2011 11:43 AM
  • You may want to try the Many to One utility on the MergeTools Add-in that I created that you can download from the following page of my Windows Live SkyDrive:

    https://skydrive.live.com/?cid=5aedcb43615e886b#cid=5AEDCB43615E886B&id=5AEDCB43615E886B%21111


    Doug Robbins - Word MVP dkr[atsymbol]mvps[dot]org
    Wednesday, October 19, 2011 9:53 AM