[Walt55]

I am trying to run a mailmerge but only want the records where "status" is
set to active with either an "A" or "a". I've tried using the rules button
but it doesn't filter out the other records. All records are still printing.
I check the field toggle & it says Skipif E ""A"" That makes no sense to
me.

If I change it to Skipif "status" "A" then the whole field disappears. I
don't know where it goes but it's gone.

[macropod[_2_]]

Hi Walt55,

Code your SKIPIF field as:
{SKIPIF {MERGEFIELD status \* Upper} "A"}

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.

--
Cheers
macropod
[MVP - Microsoft Word]


"Walt55" wrote in message ...
I am trying to run a mailmerge but only want the records where "status" is
set to active with either an "A" or "a". I've tried using the rules button
but it doesn't filter out the other records. All records are still printing.
I check the field toggle & it says Skipif E ""A"" That makes no sense to
me.

If I change it to Skipif "status" "A" then the whole field disappears. I
don't know where it goes but it's gone.

[Walt55]

Thank you.

"macropod" wrote:

Hi Walt55,

Code your SKIPIF field as:
{SKIPIF {MERGEFIELD status \* Upper} "A"}

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.

--
Cheers
macropod
[MVP - Microsoft Word]


"Walt55" wrote in message ...
I am trying to run a mailmerge but only want the records where "status" is
set to active with either an "A" or "a". I've tried using the rules button
but it doesn't filter out the other records. All records are still printing.
I check the field toggle & it says Skipif E ""A"" That makes no sense to
me.

If I change it to Skipif "status" "A" then the whole field disappears. I
don't know where it goes but it's gone.