I am creating merge letters from Outlook contacts and I have an issue: Some of the contacts being merged have a middle name and some do not. When I set up the merge document and use the following merge string for Middle Name: {IF {MERGEFIELD MIDDLE_NAME}<>""{MERGEFIELD MIDDLE_NAME}} The name prints out CORRECTLY as follows: John (one space) James (one space) Smith But... When I use the same string and merge a contact with no middle name: it prints out WRONG like this: John (2 spaces) Smith I need some assistance/directions to eliminate the 2 spaces between First Name and Second Name when there is NO middle name. Should I be doing something different? I need to have this done before my boss gets back from vacation in 2 days! Thanks for the help Kathy B
Hi Kathy, Simple: delete the space after the middlename mergefield, which you then recode as: {IF{MERGEFIELD MIDDLE_NAME}<> "" "{MERGEFIELD MIDDLE_NAME} "} -- Cheers macropod [MVP - Microsoft Word]
THANKS MACROPOD: You made my day a whole lot easier!!! -- Kathy B.