Share via

Repeating data on same mail merge page

Anonymous
2013-11-22T20:27:59+00:00

Word 2010 under Window 7 mail merge question.

I am trying to mail merge two columns of data.  The first column is a suite number and the second column is the associated name(s), some suites numbers have more than one name.   For every time the suite number repeats I want the next instance of the name to appear within the same merge page.  Here is an example

Suite      Name

1              Name1                 page1

2              Name2                 page2

2              Name3

3              Name4                 page3

4              Name5                 page4

4              Name6

4              Name7

Not sure if this is possible, please advice.

Ken

Microsoft 365 and Office | Word | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Paul Edstein 82,861 Reputation points Volunteer Moderator
    2013-11-23T02:28:19+00:00

    You can 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://windowssecrets.com/forums/showthread.php/154370-Microsoft-Word-Catalogue-Directory-Mailmerge-Tutorial

    or

    http://www.gmayor.com/Zips/Catalogue%20Mailmerge.zip

    The tutorial covers everything from list creation to the insertion & calculation of values in multi-record tables in letters. Do read the tutorial before trying to use the mailmerge document included with it.

    For some worked examples, see the attachments to the posts at:

    http://www.msofficeforums.com/mail-merge/9180-mail-merge-duplicate-names-but-different-dollar.html#post23345

    http://www.msofficeforums.com/mail-merge/11436-access-word-creating-list-multiple-records.html#post30327

    http://windowssecrets.com/forums/showthread.php/157725-Word-2010-Merge-from-excel-into-Table-Directory?p=928391&viewfull=1#post928391

    Alternatively, you may want to try one of the Many-to-One Mail Merge add-ins, from:

    Graham Mayor at http://www.gmayor.com/ManyToOne.htm; or

    Doug Robbins at https://skydrive.live.com/?cid=5aedcb43615e886b#!/?cid=5AEDCB43615E886B!cid=5AEDCB43615E886B&id=5AEDCB43615E886B%21566

    In addition to a 'Many to One' merge, the latter handles:

    • Merge with Charts

    • Duplex Merge

    • Merge with FormFields

    • Merge with Attachments

    • Merge to Individual Documents

    • Merge, Print and Staple

    Was this answer helpful?

    0 comments