Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #5  
Old 12-16-2011, 07:23 PM
bobcharest bobcharest is offline Mail Merge - Filters adding condition not originally specified Windows XP Mail Merge - Filters adding condition not originally specified Office 2010 32bit
Novice
Mail Merge - Filters adding condition not originally specified
 
Join Date: Dec 2011
Posts: 6
bobcharest is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
I hope so, it's a fairly significant issue for some users and seems related to testing for blanks - AFAIK the rest of the filtering works OK, in which case you could leave the Print filter in place and just use the SKIPIF test for the Mailed field.
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?

When we print these labels I'm testing for the presence of other non-blank fields in addition to the print field. This give us labels for business associates, clients, personal aquaintances, etc. I agree that the problem seems to be related to testing for blanks, as after the field that has been tested for "is blank" the software inserts an "or" operand, invalidating the argument.

Thanks again,
Bob Charest
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail Merge - Filters adding condition not originally specified Saving INDV mail merges During the mail merge sedain121 Mail Merge 2 10-04-2011 07:52 PM
Mail Merge - Filters adding condition not originally specified check with condition karti Word 2 03-15-2011 06:06 AM
Mail Merge - Filters adding condition not originally specified 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

Other Forums: Access Forums

All times are GMT -7. The time now is 07:38 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft