View Single Post
  #6   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default mailmerge field conditionally suppressed

It is better to to the data manipulation in a data base rather than in a
word processor. Use the IIF() function in an Access Query and use that
Query as the data source.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"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 ?