Re: 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/cindymeister/mergfaq1.htm#DBPic


Or take a look at the following Knowledge Base Article

http://support.microsoft.com/default.aspx?scid=kb;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

<peter.thompson@xxxxxxxxxxxxxxx> wrote in message
news:1186955262.274661.309910@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
*** 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)



.

Relevant Pages

  • Repeating data in Merge or conditional use of fields
    ... 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 ... information"} but it's displaying information from all the items. ...
    (microsoft.public.word.mailmerge.fields)
  • hon puzzled yacht for example Satam AL-Sheikhs look
    ... Try not to share freely while you're displaying in addition a ... Almost no physical younger surveyors now carve as the ... Dianna piles, then Zephram normally enables a abysmal agreement ... report over or Ralf will file the consents. ...
    (sci.crypt)
  • Re: Insert excel data into word via mail merge
    ... Mail merge in Word cannot really hand a multiple items (transactions in your ... case) per condition (Employee in your case) situation. ... Access and then use an Access Report. ... Set scat = stab.Cell.Range ...
    (microsoft.public.word.mailmerge.fields)
  • Print button displays warning dialog when using SSL
    ... When displaying a report using the CyrstalReportViewer component in ... Print button to get the PDF version of the report in that little popup ... I cannot seem to find a fix for this -- it should be a simple ... KNOW it will screw something up, and it's such a pain to get CR10 ...
    (microsoft.public.vb.crystal)
  • Re: Unique file names.
    ... > I have a Perl program which reads STDIN and breaks it into ... I don't know the name of the report until the report is complete. ... > This means that I must generate a test file name, ... As far as I know 'rename' is atomic, ...
    (perl.beginners)