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 / March 2004

Tip: Looking for answers? Try searching our database.

Blank lines in addresses

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Nicki - 11 Mar 2004 15:07 GMT
I am merging lots of addresses that have different
information and varying lengths of address.  

When I merge to a letter etc, I am getting blank lines.  
ie some of the people have a title some don't so that the
ones who don't have a title of "Director, Manager" have a
blank line instead.

Is there a quick and easy remedy for this?
Ralph John - 11 Mar 2004 16:00 GMT
>-----Original Message-----
>I am merging lots of addresses that have different
[quoted text clipped - 8 lines]
>.
>Hi Niki

In the Print item in the File menu there should be an
option to choose that says something like "Don't print
blank lines when there is not data"

Ralph John
Graham Mayor - 11 Mar 2004 21:29 GMT
You can use a conditional field to insert the field and the line break when
the field has content eg

{Mergefield Lastname}{IF {Mergefield Title} <> "" "
Mergefield Title}"}

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
    Graham Mayor -  Word MVP

     Web site www.gmayor.com
 Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>

> I am merging lots of addresses that have different
> information and varying lengths of address.
[quoted text clipped - 5 lines]
>
> Is there a quick and easy remedy for this?

Rate this thread:






 
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.