#1
|
|||
|
|||
Mail merging reports with different numbers of records on each page
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 |
#2
|
||||
|
||||
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
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Merging multiple records into one document | LaniKaye | Mail Merge | 3 | 10-28-2014 05:56 PM |
Mail Merge to label L7165X, record can't auto page to next 8 records | stevencheng | Mail Merge | 3 | 09-29-2013 07:25 PM |
Need a word template for reports where the numbers update automatically | cadonn | Word | 3 | 01-24-2013 07:08 AM |
Multiple mail merge records on the same page | allenglishboy | Mail Merge | 3 | 07-18-2012 06:22 AM |
Continuous page numbers with mail merge? | Jennifer Murphy | Mail Merge | 1 | 08-11-2011 05:27 AM |