Microsoft Office Forums Mail Merge a Listing grouped by specific field

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-10-2012, 08:19 PM
KarenLS KarenLS is offline Mail Merge a Listing grouped by specific field Windows 7 32bit Mail Merge a Listing grouped by specific field Office 2010 32bit
Novice
Mail Merge a Listing grouped by specific field
 
Join Date: Nov 2012
Posts: 1
KarenLS is on a distinguished road
Default Mail Merge a Listing grouped by specific field

I want to take fields from a spreadsheet and mail merge to a listing group by one of my spreadsheet fields, as in the following example.

Group number is either Group 1-Blue or Group 2-Green or Group 3 Yellow


Item number is Unique and sequential numbers are 1-99
When the Group number changes I would like a page break
Result after mail merge:

Group 1-Blue
Item number 1
Item number 2
Item number 9
etc.
Group 2-Green
Item number 5
Item number 7
Item number 12
etc.
Group 3-Yellow
Item number 15
Item number 60
Item number 99
etc.

Where etc. are the other random item numbers

How can I do this?
Reply With Quote
  #2  
Old 11-11-2012, 02:41 PM
macropod's Avatar
macropod macropod is offline Mail Merge a Listing grouped by specific field Windows 7 64bit Mail Merge a Listing grouped by specific field Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,524
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

Hi Karen,

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...ngs-(2000-2010)
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 attachment to the posts at:
https://www.msofficeforums.com/mail-...html#post23345
https://www.msofficeforums.com/mail-...html#post30327

Alternatively, you may want to try the Many-to-One Mail Merge add-in from Graham Mayor at: http://www.gmayor.com/ManyToOne.htm
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do i ad a specific pdf file to a mail merge? mseibel Mail Merge 1 08-28-2012 07:53 PM
Mail Merge a Listing grouped by specific field specific mail merge cmccabe Mail Merge 3 06-14-2012 04:12 PM
Mail Merge a Listing grouped by specific field Mail Merge to print specific record based on mergefield criterias nicnad Mail Merge 1 02-22-2012 01:53 AM
Mail Merge a Listing grouped by specific field Mail Merge to create specific number of table rows flackend Mail Merge 2 08-24-2011 11:49 AM
Mail Merge a Listing grouped by specific field Making the IF field work (not Mail Merge) Caroline Mail Merge 5 04-11-2011 04:17 PM


All times are GMT -7. The time now is 01:08 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