How to use mail merge to create a list sorted by category in Word 2010


  • Microsoft KB explains it but in Word 2003 or below.

    I am trying to achive the same result in Word 2010 but no luck so far. Don't really know where to start in Word 2010 as it has different feature for Mail Marge comparing with Word 2003

    What I want ot acgive is:

    From Excel 2010 Spreadsheet, create a list sorfed by category in Word 2010

    Example; on Excel 2010 table a have got 3 category Names / Trials / ID

    To each names is assigned more then 10-20 different IDs. What I want is; to have (Word) printed each name with all assigned IDs. I.e Mr Brown has 20 IDs (rows) and Mr Edwards 10. So, want to manage data on Word document, when I print it off, each page shows Mr Brows and list od IDs then second page Mr Edwards and list of IDs.

    Thank you in advanced.

    Bartosz Kurowski Solution Engineer MCP, MCT, MCTS, MCITP, MOS 2007 / 2010

    Friday, February 15, 2013 2:11 PM


All replies