Microsoft Office Forums Mail merging reports with different numbers of records on each page

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-11-2015, 09:32 AM
chrisbarnettuk chrisbarnettuk is offline Mail merging reports with different numbers of records on each page Mac OS X Mail merging reports with different numbers of records on each page Office for Mac 2011
Novice
Mail merging reports with different numbers of records on each page
 
Join Date: Nov 2015
Posts: 1
chrisbarnettuk is on a distinguished road
Default 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
Reply With Quote
  #2  
Old 11-11-2015, 01:14 PM
macropod's Avatar
macropod macropod is offline Mail merging reports with different numbers of records on each page Windows 7 64bit Mail merging reports with different numbers of records on each page Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,543
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

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
[MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


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 merging reports with different numbers of records on each page 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
Mail merging reports with different numbers of records on each page Continuous page numbers with mail merge? Jennifer Murphy Mail Merge 1 08-11-2011 05:27 AM


All times are GMT -7. The time now is 01:42 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft