#1
|
|||
|
|||
Mail Merge Multiple Rows Into One Document Grouped
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:
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}”}”} But I'm only getting this sort of result (one per page) when I preview: PHP Code:
|
#2
|
|||
|
|||
I would also be cool with code that just gave me five records at a time -- regardless of any grouping.
|
#3
|
||||
|
||||
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
__________________
Graham Mayor - MS MVP (Word) (2002-2019) Visit my web site for more programming tips and ready made processes www.gmayor.com |
#4
|
|||
|
|||
Quote:
|
#5
|
|||
|
|||
The Preview function does not work when you utilize this grouped feature. In order to view the results, you must Finish & Merge.
|
Tags |
mail merge, microsoft word 2013 |
|
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 |