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.