Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 05-30-2012, 09:37 PM
tomcon tomcon is offline Problem filtering in mail merge. Windows 7 64bit Problem filtering in mail merge. Office 2010 32bit
Novice
Problem filtering in mail merge.
 
Join Date: May 2012
Posts: 1
tomcon is on a distinguished road
Default Problem filtering in mail merge.

I have a problem trying to use multiple criteria to filter on.

This seems purely like a bug or random behavior, and not a usage issue, but please tell me if this is known or what i would need to do.

I filtered on a field, SendNow=1. Fine, i got 566 reciepients.
I then added AND Field=Bounced, criteria = IsBlank.

But, instead of getting fewer recipients, in fact, at that point, all rows were selected.

So, i looked at the dialog again, and it had simply added an extra criteria, and extra "OR" criteria that ended up selecting all the records. And, this is reproducible, happens every time i try to say OK to the dialog, i can't seem to prevent it.

When i click OK, what is added is an additional critera, with "OR", and Field-Bounced=IsBlank is added again.

So, when i thought i had
SendNow=1
AND Bounced IsBlank (and then hit OK in the dialog)

what the dialog had (when i opened it again) is
SendNow=1
AND Bounced IsBlank
OR Bounced IsBlank

That is, it simply added an extra criteria as "OR Bounced IsBlank". Of course the last set will select all records.

each time i simply open the filter dialog and click OK, an extra criteria


"OR Bounced IsBlank". I've gotten it up to like 10 times in the dialog, just by opening and saying "OK". Aside from the fun, this is is a big problem. I can't make the dialog stop at just two criteria:
SendNow=1
AND Bounced IsBlank

Am i crazy? Has this been seen? How do i get ONLY the above 2 criteria to be used. Every time i say OK to the dialog, i am back to all the rows being selected, no filter at all.

Yikes, help!

Thanks
tom
Reply With Quote
 

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail Merge problem when converting to PDF roflzor Mail Merge 7 09-30-2013 06:50 AM
Problem filtering in mail merge. Mail Merge Problem Hook Mail Merge 2 01-11-2012 09:36 AM
Problem filtering in mail merge. Mail Merge for Labels Problem Debz831 Mail Merge 5 10-31-2011 01:48 AM
Mail Merge Problem JohnRG Mail Merge 0 11-02-2009 02:50 AM
problem in Mail merge rjagathe Mail Merge 0 08-12-2009 08:25 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:41 AM.


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