Hi Suzanne
As Doug mentioned in an earlier thread, it's partly a question of "where to
put your page break".
whatever you put in the TRUE result of the IF field here...
{ If { ={ COMPARE { LUIC } <> { MERGEFIELD UIC } }+{ COMPARE { LROOM } <>
{ MERGEFIELD ROOM } } } = 2
"{ MERGEFIELD UIC }{ MERGEFIELD ROOM }
" "" }
is going to appear when UIC and ROOM change (so that probably needs to have
a page break at the end - you can insert one in the result text) and perhaps
you will also need to repeat some of the fields at the beginning of that new
page. i.e. you need something like
{ If { ={ COMPARE { LUIC } <> { MERGEFIELD UIC } }+{ COMPARE { LROOM } <>
{ MERGEFIELD ROOM } } } = 2
"{ MERGEFIELD UIC }{ MERGEFIELD ROOM }
whatever else you want on page 1 followed by
<page break> (put a real page break in here)
followed by whatever text and fields you need at the top of page 2
" "" }
At the moment, my suggestion assumes that the stuff you have in "whatever
you want here" will be output for every record. This is because in this kind
of merge, the first record in the group also usually contains the data for
the first detail record in the group IYSWIM. What I am not sure about in
this case is what you mean by...
The second page is not in a table format. Rows of names are at the top of
the page.
Can you provide an example of the kind of layout you need to achieve? If you
need to avoid having paragraph marks between each record, you need to
eliminate any paragraph marks in the mail merge main document that would be
output following any of the records, and that probably also means that you
need to insert a page break at the beginning of the "heading texts", e.g.
{ If { ={ COMPARE { LUIC } <> { MERGEFIELD UIC } }+{ COMPARE { LROOM } <>
{ MERGEFIELD ROOM } } } = 2
"<page break>{ MERGEFIELD UIC }{ MERGEFIELD ROOM }
whatever else you want on page 1 followed by
<page break> (put a real page break in here)
followed by whatever text and fields you need at the top of page 2
" "" }
If you need to eliminate the page break on page 1, try
{ If { ={ COMPARE { LUIC } <> { MERGEFIELD UIC } }+{ COMPARE { LROOM } <>
{ MERGEFIELD ROOM } } } = 2
"{ IF { LUIC } <> "" "<page break>" "" }{ MERGEFIELD UIC }{ MERGEFIELD
ROOM }
whatever else you want on page 1 followed by
<page break> (put a real page break in here)
followed by whatever text and fields you need at the top of page 2
" "" }
NB, you cannot eeliminate the final paragraph mark on a page, but a
directory merge does not insert that one in the output anyway, i.e. if your
mail merge main document just ha
{ MERGEFIELD UIC }
and nothing else except that final para, your output would have
UIC1UIC2UIC3UIC4...
You may find in practice that this introduces other problems (for one thing,
I hope I have the logic the right way around!) but try it anyway.
