blanks spaces in mail merge

[Judy]

I am making envelopes via a mail merge with Word 2000 and the data is stored in Access 2000. Some names have a prefix before them but if there is no prefix ie Mr., a blank space is left before the name. How do I get the program not to leave a blank space?

 

[Ralph John]

-----Original Message-----
I am making envelopes via a mail merge with Word 2000 and

the data is stored in Access 2000. Some names have a
prefix before them but if there is no prefix ie Mr., a
blank space is left before the name. How do I get the
program not to leave a blank space?

.
Hi Judy

When you do your setup for the envelope click on the
Option box and then on the button that says Don't print
lines when data fields are empty. If there is not prefix
in a field it will not print under this option.

Ralph John

 

[Judy]

Thanks Ralph. The space is actully the space between the merge fields. So, for example, if I have Mr. John Smith, if there is no prefix the space that spearates Mr. from John shows up. After the merge runs, the evelopes without the prefix the text is one over so it's not properly aligned.
Mr. John Smith
John Smith

 

[Graham Mayor]

You need to prepare your merge document with conditional fields, that place
the information you want (and the following spaces) when the field(s) have
content and not when they don't.
e.g.
{IF {Mergefield Title} <> "" "{Mergefield Title} " ""}{Mergefield
First_Name}
the space is included in the condition
i.e.
{IF {Mergefield Title} <> "" "{Mergefield Title}<space>" "<no spaces>"}<no
space>{Mergefield First_Name}

Conditional field are coded by hand using CTRL+F9 to set the field boundary
pairs {}
--
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP
E-mail (e-mail address removed)
Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>