Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Repeating data in Merge or conditional use of fields
*** Newbie Alert *** (Felt I should warn you)
I have an application (off the shelf, not my own) that writes reports to MS Word by outputting information into a Mail Merge Source and having a DOT template pick up the fields for the report. I have a test file that has 5 items and 4 fields within each item can contain the name of an 'area' that I want to report on. eg Item 1 has to be in 2 areas so 2 of the 4 fields contain the names of the area and 2 are blank. Ultimately I wanted to structure the report for each of the 'areas' so that all the items that are linked to that area (viz the area appears in 1 of the 4 fields) are listed together. If an item had more than one area, the information would be repeated in the report. I've got down to running a separate merge for each area (to be combined in a manual process) and only want the information to be displayed if the area name appears in 1 of the 4 fields. I'm using the {IF {MERGEFIELD Name} = "Area1" "This is the information"} but it's displaying information from all the items. I tried reverse logic {IF {MERGEFIELD Name} "Area1" ""} but since there are 4 fields to check its not working as I'd expect. I'd like to be able to set up a variable so I can test each of the 4 fields and change the variable to True when I want the information displayed. Any ideas or hints would be great. Thanks (Version MS Word 2002 SP3) |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Repeating data in Merge or conditional use of fields
Sounds like you are probably trying to perform a "multiple items per
condition (=key field)" mailmerge which Word does not really have the ability to do: See the "Group Multiple items for a single condition" item on fellow MVP Cindy Meister's website at http://homepage.swissonline.ch/cindy...faq1.htm#DBPic Or take a look at the following Knowledge Base Article http://support.microsoft.com/default...b;en-us;211303 Or at: http://cornell.veplan.net/article.aspx?&a=3815 -- 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 wrote in message oups.com... *** Newbie Alert *** (Felt I should warn you) I have an application (off the shelf, not my own) that writes reports to MS Word by outputting information into a Mail Merge Source and having a DOT template pick up the fields for the report. I have a test file that has 5 items and 4 fields within each item can contain the name of an 'area' that I want to report on. eg Item 1 has to be in 2 areas so 2 of the 4 fields contain the names of the area and 2 are blank. Ultimately I wanted to structure the report for each of the 'areas' so that all the items that are linked to that area (viz the area appears in 1 of the 4 fields) are listed together. If an item had more than one area, the information would be repeated in the report. I've got down to running a separate merge for each area (to be combined in a manual process) and only want the information to be displayed if the area name appears in 1 of the 4 fields. I'm using the {IF {MERGEFIELD Name} = "Area1" "This is the information"} but it's displaying information from all the items. I tried reverse logic {IF {MERGEFIELD Name} "Area1" ""} but since there are 4 fields to check its not working as I'd expect. I'd like to be able to set up a variable so I can test each of the 4 fields and change the variable to True when I want the information displayed. Any ideas or hints would be great. Thanks (Version MS Word 2002 SP3) |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional use of merge fields suddenly failing | Mailmerge | |||
How do I stop mail merge address block repeating fields twice? | Mailmerge | |||
how do I stop merge data from repeating? | Mailmerge | |||
create conditional data in label mail merge | Mailmerge | |||
Skiping Repeating merge fields | Mailmerge |