![]() |
#1
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
Paul,
Thank you for such a quick reply! That worked perfectly. |
![]() |
Tags |
categories, mail merge, page break |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
toughiv | Mail Merge | 38 | 10-24-2014 06:58 PM |
![]() |
elisa2013 | Mail Merge | 5 | 03-14-2014 02:35 AM |
![]() |
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 |
![]() |
GeoB | Mail Merge | 3 | 09-08-2011 11:03 PM |