![]() |
|
#1
|
|||
|
|||
|
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. |
| 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 |
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 |
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 |
Conditional color fill based on presence of data
|
avanderh | Excel | 11 | 07-28-2011 09:10 AM |