Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
osbornauto osbornauto is offline
external usenet poster
 
Posts: 3
Default 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?
 
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail merge and Excel filtering BeetleB Mailmerge 4 November 29th 07 09:05 AM
VB code for filtering mail merge Bev Mailmerge 4 June 13th 06 10:50 PM
Filtering from Access Database novice Mailmerge 1 June 10th 06 09:27 AM
Filtering in Mail Merge Labels Word 2000 DannyJ Mailmerge 1 May 19th 05 07:46 AM
Mail Merge - Filtering data Louise Mailmerge 0 January 31st 05 02:41 PM


All times are GMT +1. The time now is 09:31 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"