Word 2007 mail merge for catagory listing, not listing in the return of the data. Steve1445 <blue.kahuna[ at ]gmail.com> 11/5/2008 3:28:03 PM 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.

Re: Word 2007 mail merge for catagory listing, not listing in the return of the data. "Doug Robbins - Word MVP" <dkr[ at ]REMOVECAPSmvps.org> 11/5/2008 7:27:18 PM 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" <blue.kahuna[ at ]gmail.com> wrote in message news:be058ddd-7b6d-4258-9cb9-8068887e532f[ at ]r36g2000prf.googlegroups.com... [Quoted Text] >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.

Re: Word 2007 mail merge for catagory listing, not listing in the Steve1445 11/6/2008 11:42:01 AM Hi Doug, yes the document type is Directory. Thank you for your response your second answer may possibly the way to go. Steve "Doug Robbins - Word MVP" wrote: [Quoted Text] > 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" <blue.kahuna[ at ]gmail.com> wrote in message > news:be058ddd-7b6d-4258-9cb9-8068887e532f[ at ]r36g2000prf.googlegroups.com... > >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. > > >