Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / December 2003

Tip: Looking for answers? Try searching our database.

blanks spaces in mail merge

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Judy - 08 Dec 2003 20:16 GMT
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 - 08 Dec 2003 21:08 GMT
>-----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 - 09 Dec 2003 00:51 GMT
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 - 09 Dec 2003 09:04 GMT
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 {}
Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
    Graham Mayor -  Word MVP
      E-mail gmayor@mvps.org
  Web site www.gmayor.com
 Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>

> Thanks Ralph. The space is actually the space between the merge
> fields.  So, for example, if I have Mr. John Smith, if there is no
>  prefix the space that separates Mr. from John shows up. After the
> merge runs, the envelopes without the prefix the text is one over so
> it's not properly aligned. Mr. John Smith John Smith
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.