Word Merge Problem-Middle Name Field printing with Extra Space

K

KathyB

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
 
M

macropod

Hi Kathy,

Simple: delete the space after the middlename mergefield, which you then recode as:
{IF{MERGEFIELD MIDDLE_NAME}<> "" "{MERGEFIELD MIDDLE_NAME} "}
 
K

KathyB

THANKS MACROPOD: You made my day a whole lot easier!!!
--
Kathy B.


macropod said:
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]


KathyB said:
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
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Space problem with some applications 0
Page numbering with Merged Document and IF statements 1
Remove extra space in name when no middle initial is available 0
Extra space when there is no middle initial in mail merge? 3
Function to Combine Names and Middle Initital In Various Formats 3
Problem arranging mail merge fields 2
Remove extra space between first and last names in merge 1
parsing a full name out into Last, First, Middle 2

Top