Skip next record if... Word2007

W

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.
 
M

macropod

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.
 
W

Walt55

Thank you.

macropod said:
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 said:
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top