![]() |
#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 |
|
![]() |
||||
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 |
![]() |
BradRichardson | Excel | 2 | 01-03-2017 12:25 AM |
![]() |
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 |
![]() |
avanderh | Excel | 11 | 07-28-2011 09:10 AM |