Thanks Peter - doesn't work though, I just get nothing at all printed with
either condition.
Can you verify that /all/ the {} are the special field code braces (that'#s
the usual problem with nested fields) ? If you click Alt-F9, you should see
the "field codes". Then if you try to select (say) the first { in any of the
fields, Word should select the whole field.
If you just insert { MERGEFIELD organisation_name } on its own, is it
definitely blank when it is null in Access? (e.g. try putting something like
x{ MERGEFIELD organisation_name }x and see if anything appears between the
two "x" s when you update the field.
If you're running from within Access, the most likely problem is that Word
is simply not connecting to its data source. However, if you enable the Mail
Merge tool bar, it should be reasonably obvious one way or the other because
typically most of the icons after the first two will be greyed f there is no
connection.
Peter Jamieson
"Angelaf" wrote in message
news
Thanks Peter - doesn't work though, I just get nothing at all printed with
either condition. It may be because the merge is using Access fields and
running from within an Access application. Whne inserting single
Mailmerge
fields they are enclosed in angle brackets
Maybe it can't be done ........
"Peter Jamieson" wrote:
Try the following nested fields:
{ IF "{ MERGEFIELD organisation_name }" = "" "{ MERGEFIELD
contact_name }"
"{ MERGEFIELD organisation_name }" }
You can insert each pair of the special field braces "{}" using ctrl-F9
and
type all the remaining text in the usual way.
Peter Jamieson
"Angelaf" wrote in message
...
I want one mailmerge field to be conditionally suppressed if another is
not
null
ie: if isnull organisation_name then contact_name
One name only to appear - that is Contact name to appear instead of
Organisation name only if there is no Organisation name .
I can't get this to work. Any ideas please ?