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 Merge Field

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Squid - 05 Mar 2004 20:08 GMT
I have a mail merge for addresses:
Name
Address1
Address2
City, State, Zip

How do I make City, State Zip become immediately
underneathe Address1, if Address2 is blank?  

Usually my mail merge documents do that, but for some
reason its not happening with this document.

TIA
Mike
Graham Mayor - 06 Mar 2004 05:54 GMT
You can do it with a conditional field - use CTRL+F9 to set each pair of
field boundaries and insert the field information by hand.

{Mergefield Name}
{Mergefield Address1}{If {Mergefield Address2} <> "" "
{Mergefield Address2}"}
{Mergefield City} etc

ie if Address2 is not empty, insert a line break foillowed by the content of
the field.
The line break is inserted in the field result.

Signature

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

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

> I have a mail merge for addresses:
> Name
[quoted text clipped - 10 lines]
> TIA
> Mike
 
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.