Thanks Peter, I did exactly as you mentioned, but I could not really make it
work. May be because my column order is product, region and revenue and so
when I am populating product, revenue is still not populated? Does the order
matter when evaluating condition?
"Peter Jamieson" wrote:
Something more like...
{ IF { MERGEFIELD revenue } = 0 "" "{ MERGEFIELD prod }" }
All the {} have to be the special field code brace pairs that you can
insert using ctrl-F9
Peter Jamieson
http://tips.pjmsn.me.uk
omsoft wrote:
I have a table in mail merge which is being populated by an Access table.
It has tree columns - product, region, revenue and five rows.
I want to create a mergefield where if revenue = 0 then leave product and
region blank.
I have added the field as below. But it does not work. Can someone please
tell me what I am doing wrong? Thanks much.
{IF{MERGEFIELD rev = 0 """" {MERGEFIELD prod}}}