If/And/Or Statement further refined (macropod are you out there?)

[MarvInBoise]

Jean-Guy has helped me extensively with my Excel/Word mailmerge challenge
thus far, but now the saga continues.

First page of my letter is inserting appropriate paragraphs according to
Excel fields (all fields in Excel are either "Y" or "N" and there are 8
fields in total). This part is working fine (thanks Jean-Guy).

Next challenge is second page: If my Excel fields, I'll call them Field1,
Field2, Field3, and Field4 are equal to "Y" -- any one of them = to "Y" --
then I want to generate the second page of my letter; if all of them are
equal to "N" then I don't want to generate the second page, only the first
page.

Any help is greatly appreciated!

Thanks!

 

[Peter Jamieson]

How about

{ IF "{ MERGEFIELD Field1 }{ MERGEFIELD Field2 }{ MERGEFIELD Field3 }{
MERGEFIELD Field4 }" = "NNNN" "" "put all your second page text and fields
in here" }

Peter Jamieson