worked like a charm, thanks!
"Peter Jamieson" wrote:
[Quoted Text] > 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" } } > > > -- > Peter Jamieson > http://tips.pjmsn.me.uk> > "KFreds" <KFreds[ at ]discussions.microsoft.com> wrote in message > news:2EB4FE11-241C-4CC1-8E8D-8DD2B3436042[ at ]microsoft.com... > >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? > > |