Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 01-11-2022, 09:59 AM
MLSTyburg MLSTyburg is offline If/Then/Else statement using presence of a / vs not present as criteria Windows 10 If/Then/Else statement using presence of a / vs not present as criteria Office 2019
Novice
If/Then/Else statement using presence of a / vs not present as criteria
 
Join Date: Jan 2022
Posts: 2
MLSTyburg is on a distinguished road
Default If/Then/Else statement using presence of a / vs not present as criteria

I'm using a sort_name field in Excel as my criteria to merge information into my word document. Within the sort_name field there is always data; some with a / separating lname from fname and sometimes it is the name of an organization (no lname/fname). I'm not successfully using the criteria of the / to distinguish whether or not to imput something in my document or not. Does anyone know if that is possible.
Currently my merge statement looks like:
{ IF {MERGEFIELD sort_name} <> */* "via the {MERGEFIELD sort_name} " " " }
the result of the above is inserting the contents of ALL sort_name fields in each letter.

My thought is IF sort_name contains / insert sort_name IF NOT don't insert anything.
Reply With Quote
 

Tags
if/then/else, mergefields



Similar Threads
Thread Thread Starter Forum Replies Last Post
Converting a Select statement in Excel to an update statement shabbaranks Excel Programming 5 10-31-2018 11:47 PM
If/Then/Else statement using presence of a / vs not present as criteria Create a unique list of values that match a criteria, sorted in order of another criteria BradRichardson Excel 2 01-03-2017 12:25 AM
If/Then/Else statement using presence of a / vs not present as criteria Sum based on multiple criteria (one of the criteria is not unique) until a threshold is reached. phillipsdp Excel 1 11-09-2016 12:53 AM
Outlook, 5 day appointments and communicator presence dowalker Outlook 0 10-28-2011 12:23 PM
If/Then/Else statement using presence of a / vs not present as criteria Conditional color fill based on presence of data avanderh Excel 11 07-28-2011 09:10 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:59 PM.


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