Mail merging reports with different numbers of records on each page

[chrisbarnettuk]

Hi,
I have an Excel spreadsheet with different numbers of students in each registration group that I want to mail merge their data to a single letter on Word.

I can see that there are several examples of similarish situations out there but unfortunately it's been a long time since I had my head around any coding like this and I need to get some reports out as soon as possible.



e.g.
NAME REG STANDARD
Fred Smith A1 Green
Joe Bloggs A1 Amber
Ged Roberts A1 Green
Frank Field A1 Green
Vicky Roberts A2 Amber
Caitlin Smith A2 Red
Luke Edwards A3 Green
Holly Williams A3 Green
Ciaran West A3 Amber

So on the Word document page 1 would tell the A1 tutor all the information about Fred, Joe, Ged & Frank; page 2 would tell A2 tutor about Vicky, Caitlin etc.

I would be really grateful if anyone could give me an idea about the best way of achieving this or even better specific code for the three fields.
thanks


Chris

[macropod]

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/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.

The field coding for this is complex. However, since the tutorial document includes working field codes for all of its examples, most of the hard work has already been done for you - you should be able to do little more than copy/paste the relevant field codes into your own mailmerge main document, substitute/insert your own field names and adjust the formatting to get the results you desire. For some worked examples, see the attachments to the posts at:
https://www.msofficeforums.com/mail-...html#post23345
https://www.msofficeforums.com/mail-...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