Mail Merge with database and filtering
Working with Office '07, I have a Word document (postcard) that pulls mail
merge info from an '07 Access database table. While in Word, under the
"Mailings" tab, I click on "edit recipient list" and want to select only
persons that have a blank email address and have spent over $1,000. I create
the filter as "emailaddress" is blank AND "payamt" is greater than or equal
to 1000. Then click OK. When I get back to the document, it should only
have 4 recipients, however there are 34. It has changed the query to email
is blank and payamt is over 1000 OR email is blank. So, the query has added
another layer with the "Or email is blank". I try to clear trhe query and
start over, but same results. Any ideas?
|