Mail merge filter

[Yorick]

Using Office 2007, the filters "Is blank" and "Is not blank" don't seem to
work properly in conjunction with other filters, e.g. if I want to filter
records as follows:
Field A >= X
and Field A <= Z
and Field B = 10
and Field C Is blank
the Merge malfunctions and when I return to the Filter window I find that
additional filters have been inserted.

 

[macropod]

Hi Yorick,

Instead of the filters, you could use a SKIPIF field coded along the lines of:
{SKIPIF{={IF«Field_A»= "Y" 1 0}*{IF«Field_B»= 10 1 0}*{IF«Field_C»= "" 1 0 }= 0}}
where the record is skipped if any of the conditions is not met, or:
{SKIPIF{={IF«Field_A»= "Y" 1 0}*{IF«Field_B»= 10 1 0}*{IF«Field_C»= "" 1 0 }= 1}}
where the record is skipped if all of the conditions are met.

Note: The field brace pairs (ie '{ }') for the above example are created via Ctrl-F9 - you can't simply type them or copy & paste
them from this message. Likwise, you can't type the chevrons (ie '« »') - they're part of the actual mergefields, which you can
insert from the mailmerge toolbar.