Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
mailmerge field conditionally suppressed
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 ? |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
mailmerge field conditionally suppressed
"Angelaf" wrote: 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 ? The fields are form an Access database |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
mailmerge field conditionally suppressed
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 ? |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
mailmerge field conditionally suppressed
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 ? |
#5
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
mailmerge field conditionally suppressed
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 ? |
#6
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
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 ? |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Setting Date property in a form field | Microsoft Word Help | |||
Mailmerge - Firstname truncate to Initial?... | Mailmerge | |||
Help on Mailmerge field (field length) - field getting truncated | Mailmerge | |||
WORD mailmerge field switchs do not work | Mailmerge | |||
bitmap mailmerge field | Mailmerge |