Eliminating a value in a mail merge

I have a mail merge where I want to eliminate printing a field if it
contains a particular value. But I still want to print the record. It's
just the field I want to skip. Can anyone suggest how to do this?

Thanks!
Myrna

You use an IF field. For example, if you don't want to print the value of a
field called myfield when it is "M", use

{ IF "{ MERGEFIELD myfield }" = "M" "" "{ MERGEFIELD myfield }" }

All the special {} pairs can be entered using ctrl-F9. Everything else is
plain text you can type.

Peter Jamieson
wrote in message
ups.com...
I have a mail merge where I want to eliminate printing a field if it
contains a particular value. But I still want to print the record. It's
just the field I want to skip. Can anyone suggest how to do this?

Thanks!
Myrna

Thanks, this sounds good. Now one more question - how do I do this if I
want to say 'don't print this field if it contains the word "blank" '

I guess I need more help than I thought - where do I put the IF
statement? I thought it would go on the mail merge document but that
doesn't seem to work.

Sorry if I misunderstood - you can't do a test using simple fields for 'this
field's text contains the word "blank"' unless you happen to know that
"blank" is at the beginning or end of the text.

You may be able to do that
a. in the data source before you merge, or
b. using a DATABASE field if the data source uses a suitable dialect of SQL
(it is difficult to recommend this approach anyway)
c. using VBA and Word's mailmerge events to examine the content of the
field before each record is merged.

Peter Jamieson

wrote in message
oups.com...
Thanks, this sounds good. Now one more question - how do I do this if I
want to say 'don't print this field if it contains the word "blank" '

It does, but if you need to detect the word "blank" anywhere in the mere
field text, it won't work, sorry.

Peter Jamieson
wrote in message
oups.com...
I guess I need more help than I thought - where do I put the IF
statement? I thought it would go on the mail merge document but that
doesn't seem to work.

I looked at doing it in the select but this will delete the records
having the word 'blank'. I'm not sure how to say that I want to keep
the record but clear the field for this merge. Any thoughts?

You could use an expression in the SELECT to create another field, e.g. in
Jet SQL, something like

SELECT iif(instr(myfield,'blank',1) = 0, myfield, '') AS 'mynewfield', *
FROM ....

(My syntax probably isn't quite right there)

Peter Jamieson
wrote in message
oups.com...
I looked at doing it in the select but this will delete the records
having the word 'blank'. I'm not sure how to say that I want to keep
the record but clear the field for this merge. Any thoughts?

You could use an expression in the SELECT to create another field, e.g. in
Jet SQL, something like

SELECT iif(instr(myfield,'blank',1) = 0, myfield, '') AS 'mynewfield', *
FROM ....

(My syntax probably isn't quite right there)

Peter Jamieson

wrote in message
oups.com...
I looked at doing it in the select but this will delete the records
having the word 'blank'. I'm not sure how to say that I want to keep
the record but clear the field for this merge. Any thoughts?

Can we clarify what is in this field? Does it contain just the word 'blank'
or does it contain 'blank' and some other text?
Are you merging just that field?


--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


wrote:
I looked at doing it in the select but this will delete the records
having the word 'blank'. I'm not sure how to say that I want to keep
the record but clear the field for this merge. Any thoughts?