+ Reply to Thread
Results 1 to 2 of 2

Can someone explain how to make a sorted list with mail merge?

  1. #1
    Forum Contributor
    Join Date
    08-06-2012
    Location
    United States
    MS-Off Ver
    Excel 2013
    Posts
    119

    Can someone explain how to make a sorted list with mail merge?

    Here is the Microsoft explanation of what I want to create, but I can't seem to figure out how to make it work.
    http://support.microsoft.com/kb/294686#2

    Basically what I want is a mail merge from an excel sheet that has more than one row per record (maybe not the best wording, but here is what I have):

    **Excel List**

    Vendor Stock Item
    Vendor 1 111 Item 1
    Vendor 1 222 Item 2
    Vendor 2 333 Item 1
    Vendor 2 444 Item 2
    Vendor 2 555 Item 3
    Vendor 2 666 Item 4
    Vendor 3 777 Item 1
    Vendor 3 888 Item 2

    And here is what I want:

    **Mail Merge**
    Vendor 1
    12345 - Item 1
    23456 - Item 2

    ----Page Break----

    Vendor 2
    34567 - Item 1
    45678 - Item 2
    56789 - Item 3
    67890 - Item 4

    ----Page Break----

    Vendor 3
    98765 - Item 1
    65432 - Item 2

    Each vendor has a different number of items.

  2. #2
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,726

    Re: Can someone explain how to make a sorted list with mail merge?

    See my Microsoft Word Catalogue/Directory Mailmerge Tutorial at:
    http://windowssecrets.com/forums/sho...merge-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-m...html#post23345
    http://www.msofficeforums.com/mail-m...html#post30327
    http://windowssecrets.com/forums/sho...l=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 http://bit.ly/1hduSCB

    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
    Cheers,
    Paul Edstein
    [Fmr MS MVP - Word]

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 8
    Last Post: 11-05-2014, 10:27 PM
  2. Paring list for mail merge from second list - Index Match?
    By ABI_Consulting in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-02-2012, 09:35 PM
  3. Replies: 2
    Last Post: 07-12-2012, 08:11 PM
  4. [SOLVED] Mail Merge to make picture badges for employees (2003)
    By Webtekr in forum Word Formatting & General
    Replies: 0
    Last Post: 03-02-2009, 04:51 AM
  5. Using mail merge to create sorted list in word
    By jkanclerz in forum Excel General
    Replies: 0
    Last Post: 11-28-2007, 02:47 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1