Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Word 2007 mail merge for catagory listing, not listing in the returnof the data.
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. |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Word 2007 mail merge for catagory listing, not listing in the return of the data.
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/show...?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" wrote in message ... 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. |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Word 2007 mail merge for catagory listing, not listing in the
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: 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/show...?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" wrote in message ... 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. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Listing the merge variables from all the dot documents | Mailmerge | |||
directory mail merge: auto pop-up template for the final listing?? | Mailmerge | |||
Multiple listing flyer for word | Page Layout | |||
Directory listing in word ? | New Users | |||
Listing mulitple records for the same client in a mail merged lett | Mailmerge |