Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Empty Merge fields then substitute text
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 |
#2
|
|||
|
|||
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. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Mary wrote: 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 |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can you create a multi-layered merge where certain merge fields a. | Mailmerge | |||
Empty Mail Merge Fields | Microsoft Word Help | |||
Empty Mail Merge Fields | Microsoft Word Help | |||
Outline | Page Layout | |||
Word 2002 Mail Merge - merging to new doc displays blank empty dia | Mailmerge |