Mail Merge Inserts

[Clive Prideaux]

How do "Skip Record If" and "Next Record If" work? I would
like to insert a variable only if that variable has a
particular value. Thanks for your help.

 

[Peter Jamieson]

SKIP IF and NEXT IF etc. make Word move to the next /record/ To make the
output appear different depending of the value of a field, you need to do
one of the following:
a. ensure the "Suppress Blank Lines in Addresses" option is checked. This
actually makes any line containing nothing except empty fields disappear,
unless you're using Word XP or later and the lines are inside the result of
another field such as an IF. If you are using Word XP or later you also have
to revive the old MailMergeHelper dialog box using Tools|Customize if you do
/not/ what this option to be set
b. use an { IF } field, e.g.

{ IF "{ MERGEFIELD myfield }" = "A" "A" "" }

or whatever.
c. in Word XP and later you may be able to use additional switches to get
what you want when the field is non-blank, but I don't think itis applicable
in the case you describe.

 

[Clive]

Peter

Thanks for your help. I think we're getting closer. What
if I wanted to suppress a variable if it equaled the
value "downtown" and display it in all other cases. In
other words the IF statement has to specify the output of
the variable not a text statement when true and blanks
when false.

Clive

 

[Peter Jamieson]

Try

{ IF "{ MERGEFIELD myfield }" = "downtown" "" "{ MERGEFIELD myfield }" }