RE: Merge Problem - Middle Name Field printing with extra space

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

I am working on creating merge letters from Outlook contacts. 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 names 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. Please help. I need to
have this done before my boss gets back from vacation in 2 days!

Thanks

Kathy B


"KathyB" wrote:

I am creating merge letters within Word using information from my Outlook
Contacts. After completing the merge, the suffix appears without a "comma"
and "space" after the last name - it looks like this: Mr. Robert JonesJr.
What can I do to correct this so it appears correctly like this: Mr. Robert
Jones, Jr. Thank you.
--
Kathy B.
.

Relevant Pages