Merge Problem - Suffix Problem-No Comma and Space after Last Name

[KathyB]

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.

 

[Doug Robbins - Word MVP]

Instead of using the Address Block, insert the individual merge fields in
the configuration that you want them, and to deal with the suffix, use an
If...then...Else field construction such as

{ IF { MERGEFIELD Suffix } <> "" ", {MERGEFIELD Suffix}" "" }

You must use Ctrl+F9 to insert each pair of field delimiters and you use
Alt+F9 to toggle off their display.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

 

[KathyB]

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