Word 2007 mail merge for catagory listing, not listing in the returnof the data.

[Steve1445]

I have followed this article http://support.microsoft.com/kb/294686/
to the letter. I have re-created their example with an Excel
spreadsheet and have used my own. In either case I cannot get the
result to sort the data with a heading and sub information. Each
record continues to show up on its own page (without the use of a
forced page break).

The code, straight out of the KB article:

{IF {MERGESEQ} = "1" " {MERGEFIELD CITY}
" ""}{SET PLACE1{MERGEFIELD CITY}}
{IF {PLACE2} <> {PLACE1}

{MERGEFIELD CITY}

{MERGEFIELD EMPLOYEE}{MERGEFIELD SALES}""{MERGEFIELD CITY}{MERGEFIELD
SALES}"}{SET PLACE2{MERGEFIELD CITY}}

I can toggle through the code and all looks like it is working, just
not listing the information in the pages as it ought to. I am using
this in a more complex project but if I can't get the basic stuff to
display correctly ...

I am using Word and Excel 2007 for this.

 

[Doug Robbins - Word MVP]

Is your mail merge main document of the Directory (or in versions before
XP/2002, it was called Catalog) type? It must be of that type for that
field construction to work.

For a more detailed explanation than is given in the Knowledge Base article,
see:

http://cornell.veplan.net/article.aspx?&a=3815

or fellow MVP, macropod's tutorial on Catalogue/Directory Mailmerges at:

http://www.wopr.com/cgi-bin/w3t/showthreaded.pl?Number=731107

If, as you say this is part of a more complex process, you possibly should
be using a "roll-your-own" equivalent to mail merge that uses a template
containing docvariable fields in place of merge fields and contains VBA code
to iterate through the data source, creating a new document from the
template each time the data in the "key" field (or fields) change,
populating variables in the document with the "static" data from those "key"
fields and using code to insert the data from the other fields in the group
of records having the same data in the "key" fields.

--
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

 

[Steve1445]

Hi Doug, yes the document type is Directory. Thank you for your response your
second answer may possibly the way to go. Steve