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

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

You have the spaces outside your fields, so naturally they are an immutable
part of the document. Instead, include the space following the middle name
in its field, as follows:

{ IF { MERGEFIELD MIDDLE_NAME }<>"" "{ MERGEFIELD MIDDLE_NAME } " }

That is, put your TrueText in quotes and include a space after (or before,
depending on where the space outside the IF field is) the merge field.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

"KathyB" <KathyB@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:E6B5030F-B4BE-4EB0-BC34-049D6AE19CEC@xxxxxxxxxxxxxxxx
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