Excel cell filler for word merge document
I found this, but do not know how to implement it:
The following conditional MERGEFIELD fields remove the blank space if the
middle initial field is blank. For example, given the following fields in a
mail merge main document,
<<FNAME <<MI <<LNAME
the following conditional IF field eliminates a blank space caused by an
empty middle initial field:
{MERGEFIELD FNAME}{IF {MERGEFIELD MI} < "" "{MERGEFIELD MI} "}{MERGEFIELD
LNAME}
"Shawna" wrote:
I am using Excel as a database for letter mail merge to Word.
I have "first name", "middle initial", "last name" fiels in the merge
document.
Not all ppl have middle initials so Word is inserting an extra space in
those letters.
Is there a filler that I can put in those cells with no initial to keep Word
from inserting that extra space?
Thank you in advance for any suggestions.
Shawna
|