Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 09-22-2024, 03:00 PM
Ren1975 Ren1975 is offline Help! Multiple conditional statements in mail merge Windows 10 Help! Multiple conditional statements in mail merge Office 2010
Novice
Help! Multiple conditional statements in mail merge
 
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
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Help! Multiple conditional statements in mail merge Mail Merge - Conditional Statements Utang Mail Merge 2 03-11-2024 03:35 AM
Help! Multiple conditional statements in mail merge Multiple Conditional formating within MS Mail Merge from Excel SCOATS Mail Merge 3 06-05-2019 06:55 PM
Help! Multiple conditional statements in mail merge IF Statements for a several ranges of values using Mail Merge Jennifert Mail Merge 2 05-01-2019 09:40 PM
I know nothing about mail merge, but need help with conditional statements briyosa Word 1 03-27-2017 10:17 PM
Help! Multiple conditional statements in mail merge Using multiple IF statements on a mail merge ajh19742000 Mail Merge 1 11-01-2016 06:11 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:24 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft