grouping and page breaks in a merge

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tom - 21 Apr 2005 20:38 GMT

I am trying to get a mail merge to put city into a table, show all records
for the city into a second table on the same page and then start a new page
whenever the city changes.

I tried to use the following code from Microsoft KB but it does not work:

{ If { MERGESEQ } = "1" "{ MERGEFIELD CITY }¶
" ""}{ SET Place1 { MERGEFIELD CITY }}¶
{ If { Place2 } <> { Place1 }"¶
----------------------------Page Break--------------------------------
{ MERGEFIELD CITY }¶
¶
{ MERGEFIELD EMPLOYEE } { MERGEFIELD SALES }" "{ MERGEFIELD EMPLOYEE } {
MERGEFIELD SALES }" }{ SET Place2 { MERGEFIELD CITY }}¶

I pasted the code as if from Microsoft's website becuase I could not figure
out out to create the formulas.

Reply to this Message

Graham Mayor - 22 Apr 2005 06:24 GMT

You cannot paste fields from a KB article, you have to recreate them using
CTRL+F9 for each pair of field boundaries {}

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> I am trying to get a mail merge to put city into a table, show all
> records for the city into a second table on the same page and then
[quoted text clipped - 14 lines]
> I pasted the code as if from Microsoft's website becuase I could not
> figure out out to create the formulas.

Reply to this Message

Tom - 22 Apr 2005 13:02 GMT

I can get Word to create the brackets using CRTL F9 but I can't seem to get
it to create the expression inside the brackets as follows:

{ If { MERGESEQ } = "1" "{ MERGEFIELD CITY }¶

> You cannot paste fields from a KB article, you have to recreate them using
> CTRL+F9 for each pair of field boundaries {}
[quoted text clipped - 17 lines]
> > I pasted the code as if from Microsoft's website becuase I could not
> > figure out out to create the formulas.

Reply to this Message

Graham Mayor - 22 Apr 2005 14:44 GMT

What you have here is part of a field sequence (which continues on the line
you have not pasted). The pilcrow '¶' merely indicates that you should press
the enter key at that point. The rest you will have to type between the
field brackets.

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> I can get Word to create the brackets using CRTL F9 but I can't seem
> to get it to create the expression inside the brackets as follows:
[quoted text clipped - 30 lines]
>>> I pasted the code as if from Microsoft's website becuase I could not
>>> figure out out to create the formulas.

Reply to this Message

Doug Robbins - 22 Apr 2005 14:46 GMT

Select each portion of the text that you want enclosed in field delimiters
and Press Ctrl + F9 or use Ctrl + F9 to insert each pair of empty field
delimiters and then use the keybaord to create the required expression.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

>I can get Word to create the brackets using CRTL F9 but I can't seem to get
> it to create the expression inside the brackets as follows:
[quoted text clipped - 23 lines]
>> > I pasted the code as if from Microsoft's website becuase I could not
>> > figure out out to create the formulas.

Reply to this Message