Good morning,


I am seeking help with nested if statements in mail merge & am going around in circles trying to figure out.

I need to create a paragraph with the following conditions -

IF (Mergefield Cover Type) is E1 and (Mergefield Overseas) is not blank "Sentence for this cover"

Then the rest of the paragraph needs to return different values depending on one to three conditions at a time (I am attempting to nest it all together) -

IF (Mergefield Waits Apply) = Y "Sentence for waits apply"
or
IF (Mergefield Waits Apply) = Y and (Mergefield Previous Extras) = N "Sentence for previous extras"
or
IF (Mergefield Waits Apply) = Y and (Mergefield Previous Extras) = Y and (Mergefield Upgrade Extras) = Y "Sentence for upgrading waits"

They need to return a blank if they are not true

Any assistance from your logical minds would be greatly appreciated
Renee

From what you describe, your fields should be coded as:

and:
If your 'Previous Extras' data field can have content other than Y or N, use:
You can omit the "Sentence for not Y/N" if there's not output for that condition.

Note: The field brace pairs (i.e. '{ }') for the above examples are all created in the document itself, via Ctrl-F9 (Cmd-F9 on a Mac or, if you’re using a laptop, you might need to use Ctrl-Fn-F9); you can't simply type them or copy & paste them from this message. Nor is it practical to add them via any of the standard Word dialogues. The spaces represented in the field constructions are all required.

For a macro to convert the above field code representations into working field codes, see Convert Text Representations of Fields to Working Fields in the Mailmerge Tips and Tricks 'Sticky' thread at the top of this page: https://www.msofficeforums.com/mail-...ps-tricks.html

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

The following may also assist:

• Nested IF Fields - A method to create them
• Convert Fields to Text and Vice Versa by Word MVP Graham Mayor

I recommend downloading and saving Paul Edstein's Mailmerge Tips and Tricks. Read it. It will help with more than this problem.

Thank you for your assistance Paul & Charles, all sorted now