Mail Merge - Filters adding condition not originally specified

macropod · #1 12-17-2011, 01:06 AM

Quote:

Originally Posted by bobcharest

Hi Paul, Thanks again for the help. I'm realizing (as I'm learning to insert the fields) that I don't think SKIPIF will work for me. I actually want the records that match both of my conditions to be present in the merged document so I can check our mailings. To skip the records where both conditions are met would give me the opposite of what I want I think. Am I wrong about this?

Hi Bob,

With a 'Print = X' filter, only the records that have the 'X' would be passed through to the SKIPIF field for 'Mailed' testing. Conversely, with a 'Print <> X' filter, only the records that lack the 'X' would be passed through to the SKIPIF field for 'Mailed' testing. The 'Mailed' SKIPIF test can then be based on the presence or absence of something in that field, via:
{SKIPIF {MERGEFIELD Mailed} = ""}
or:
{SKIPIF {MERGEFIELD Mailed} <> ""}

FWIW, if you want to test for multiple conditions using just a SKIP field, you can code the field along the lines of:

{SKIPIF{={IF{MERGEFIELD Mailed} = "" 1 0}*{IF{MERGEFIELD Print} = "X" 1 0}> 0}
and:
{SKIPIF{={IF{MERGEFIELD Mailed} = "" 0 1}*{IF{MERGEFIELD Print} = "X" 0 1}> 0}
etc if both conditions must be met, or:
{SKIPIF{={IF{MERGEFIELD Mailed} = "" 1 0}+{IF{MERGEFIELD Print} = "X" 1 0}> 0}
and:
{SKIPIF{={IF{MERGEFIELD Mailed} = "" 0 1}+{IF{MERGEFIELD Print} = "X" 0 1}> 0}
etc if either condition must be met.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Saving INDV mail merges During the mail merge	sedain121	Mail Merge	2	10-04-2011 07:52 PM
check with condition	karti	Word	2	03-15-2011 06:06 AM
Formula in a Cell with condition?	Learner7	Excel	1	07-19-2010 10:10 AM
Retrict Method Condition	markp	Outlook	0	12-22-2005 05:38 PM
Junk mail Filters of Outlook 2003	RoscoeL	Office	0	11-24-2005 12:33 AM