View Single Post
 
Old 09-22-2024, 03:00 PM
Ren1975 Ren1975 is offline Windows 10 Office 2010
Novice
 
Join Date: Mar 2024
Posts: 9
Ren1975 is on a distinguished road
Default Help! Multiple conditional statements in mail merge

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
Reply With Quote