data fields

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

MariA - 03 Mar 2005 06:19 GMT

I have two address fields in my data source. One is a postal address and the
other is an address field. I want to know if there is some way of using the
postal address when available, but if the field is blank then word needs to
use the other address with out leaving blank lines.

Thanks

Reply to this Message

Graham Mayor - 03 Mar 2005 07:50 GMT

Use a conditional field. Substitute your field names as appropriate

{IF {Mergefield Postal_address} <> "" "{Mergefield Postal_Address}"
"{Mergefield Alternative_Address}"}

Note the field boundaries are set with CTRL+F9

Signature

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

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

> I have two address fields in my data source. One is a postal address
> and the other is an address field. I want to know if there is some
[quoted text clipped - 3 lines]
>
> Thanks

Reply to this Message