|
#1
|
|||
|
|||
Mail Merge - Send Each Category to a New Page
I want to create a list of contact information of participants by table where they are seated. I also want one page for each table. The code below does what I need, except that it prints one page per person, instead of one page per table. Can anyone help?
{QUOTE{IF{MERGESEQ}=1 {SET Key””}}”{IF{MERGEFIELD Table}<>{REF Key} “IF{MERGESEQ}>1} Table {MERGEFIELD Table} {MERGEFIELD First_} {MERGEFIELD Last} {MERGEFIELD Email} {MERGEFIELD Street} {MERGEFIELD Phone} {MERGEFIELD City_State} “} |
#2
|
||||
|
||||
Your description suggests you're using a Letter merge instead of a Directory merge. Plus your field construction is missing the code that actually inserts the page break. It should be:
{QUOTE{IF{MERGESEQ}= 1 {SET Key ""}}"{IF{MERGEFIELD Table}<> {REF Key} "{IF{MERGESEQ}> 1 {QUOTE 12}}Table {MERGEFIELD Table}{SET Key {MERGEFIELD Table}}¶ " }{MERGEFIELD First_} {MERGEFIELD Last} {MERGEFIELD Email}¶ {MERGEFIELD Street} {MERGEFIELD Phone}¶ {MERGEFIELD City_State}¶ "} where the ¶ is a real paragraph/line break.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
Thanks
Paul,
Thank you for such a quick reply! That worked perfectly. |
Tags |
categories, mail merge, page break |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Mail Merging - Mergeseq + Send Via Email Merge | toughiv | Mail Merge | 38 | 10-24-2014 06:58 PM |
How to use mail merge to create a list sorted by category in Word | elisa2013 | Mail Merge | 5 | 03-14-2014 02:35 AM |
mail merge in excel to send pdf forms | heyullama | Excel | 7 | 12-01-2013 03:32 PM |
Send e-mail message in Finish & Merge | CDTom | Mail Merge | 1 | 08-24-2012 12:52 AM |
Need advice on category sorted e-mail merge | GeoB | Mail Merge | 3 | 09-08-2011 11:03 PM |