Mergefield Question

[KFreds]

I have two mergefeld addresss, one called Vendor Address and the other is New
Address, where there is a new address in my excel sheet i want to use it, if
it is blank i want to use the Vendor address, is there a way I can do this?

 

[Peter Jamieson]

Try

{ IF "{ MERGEFIELD "New Address" }" = "" "{ MERGEFIELD "Vendor Address" }"
"{ MERGEFIELD "New Address" }" }

where all the {} are pairs of the special Field code braces that you can
insert using ctrl-F9 and everything else is plain text. Use Alt-F9 to toggle
between "field code" view and "field result" view.

You can probably reduce that to

{ IF { MERGEFIELD "New Address" } = "" { MERGEFIELD "Vendor Address" } {
MERGEFIELD "New Address" } }

 

[KFreds]

worked like a charm, thanks!

Try

{ IF "{ MERGEFIELD "New Address" }" = "" "{ MERGEFIELD "Vendor Address" }"
"{ MERGEFIELD "New Address" }" }

where all the {} are pairs of the special Field code braces that you can
insert using ctrl-F9 and everything else is plain text. Use Alt-F9 to toggle
between "field code" view and "field result" view.

You can probably reduce that to

{ IF { MERGEFIELD "New Address" } = "" { MERGEFIELD "Vendor Address" } {
MERGEFIELD "New Address" } }