Empty Merge fields then substitute text

M

Mary

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
 
G

Graham Mayor

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


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top