Mail Merge Multiple Rows Into One Document Grouped

ryano · #1 03-14-2015, 01:19 PM

I've found some help other places on the Internet to try and make this happen, but it's not working for me. Basically I have a very simple spreadsheet that looks similar to this except with many more rows and groups:

PHP Code:


			
Group   |   Name    |   Phone







Group 1 |   Ryan    | 111-222-3333
Group 1 |   Katie   | 112-223-3343
Group 2 |   Josh    | 141-181-3183
Group 2 |   Emily   | 129-831-4913
...

etc.

And I want to mail merge multiple rows onto each sheet in Microsoft Word based on the Group column. Currently, everything's loaded in Word properly (including "Group" being sorted ascending).

This is the code:

Code:

{QUOTE{IF{MERGESEQ}=1 {SET Key “”} {SET LastKey {Key}}}{IF{MERGEFIELD Group}<> {Key} “{IF{MERGESEQ}> 1”
 
{IF{MERGEFIELD Group}<> 0 {QUOTE 12}}”}{IF{MERGEFIELD Group}<> 0 “Text: {SET Key {MERGEFIELD Group}}
 
{MERGEFIELD Group \* Charformat}
 
“}”}”{IF{MERGEFIELD Group}<> 0”{MERGEFIELD Name}/{MERGEFIELD Phone}”}”}

(The above brackets were used by pressing Ctrl+F9)

But I'm only getting this sort of result (one per page) when I preview:

PHP Code:


			
Ryan / 111-222-3333

When the desired result would be the "text" in the code above, along with all of the people's names and numbers in that group.

ryano · #2 03-14-2015, 07:21 PM

I would also be cool with code that just gave me five records at a time -- regardless of any grouping.

gmayor · #3 03-15-2015, 12:08 AM

See http://www.gmayor.com/ManyToOne.htm. Or if you want to go it alone, see Paul Edstein's Catalogue Mail Merge tutorial which you can download from my web site - http://www.gmayor.com/downloads.htm

ryano · #4 03-15-2015, 08:29 AM

Quote:

Originally Posted by gmayor

See http://www.gmayor.com/ManyToOne.htm. Or if you want to go it alone, see Paul Edstein's Catalogue Mail Merge tutorial which you can download from my web site - http://www.gmayor.com/downloads.htm

Thanks -- but I believe that's where I started from, and I can't figure out why the code I wrote is presenting output the way that it is.

mcmuney · #5 03-23-2015, 04:27 PM

Quote:

Originally Posted by ryano

But I'm only getting this sort of result (one per page) when I preview:

The Preview function does not work when you utilize this grouped feature. In order to view the results, you must Finish & Merge.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Formula that can merge multiple rows with the same ID into one row	Hilwey	Excel	3	07-08-2015 08:50 PM
I want to add multiple rows into my document but I can not figure out the code	jlw15931	Mail Merge	1	02-24-2015 05:03 AM
Easy mail merge but want to suppress rows	ClaireAMAdams	Mail Merge	5	04-30-2013 02:43 PM
Mail Merge a Listing grouped by specific field	KarenLS	Mail Merge	1	11-11-2012 02:41 PM
Mail Merge multiple rows?	ender541	Mail Merge	1	08-21-2012 03:14 PM