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 2005

Tip: Looking for answers? Try searching our database.

Empty Merge fields then substitute text

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Mary - 14 Mar 2005 13:16 GMT
Using Word 2000.

I print an address in my merge letter. But if the address is empty, I
want to slightly change what prints. The address is empty if either
addrln1, city, or st is empty.

your property at 123 Main St, Orlando FL.

versus

your property.

The merge document looks like this.

your propert at <<addrln1>>, <<city>> <<st>>.

How can I change the text if the address is empty?

Thanks

Brenda
Graham Mayor - 14 Mar 2005 13:32 GMT
your property{IF {Mergefield addrln1} <> "" " at {Mergefield addrln1},
{Mergefield city} {Mergefield st}"}.

should do the trick. Enter the field boundaries {} with CTRL+F9 and type the
rest as shown.

Signature

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

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> Using Word 2000.
>
[quoted text clipped - 17 lines]
>
> Brenda

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.