Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
oli merge oli merge is offline
external usenet poster
 
Posts: 15
Default Query Criteria is lost in Recipients list in Mail Merge Word 2003

Hi,

I have got fed up with the ridiculous and endless connection problems when
mail merging from Excel to Word 2003 so have started replacing all my mail
merges sources with Access tables.

This seemed to be working fine until the last two sets of documents I have
been setting up have started losing my query settings each time i input them
to the recipients list.

Its driving me mad - about 15 other documents worked fine when I input my
criteria using the little arrows next to field names on the recipients list.
However, now this happens:

The recipient list intially is reduced to the correct amount based on the
criteria i entered. I then close it and click on goto last record on the
record selector. Now I get far too many records for the criteria i input. I
do back to the recipients list - advanced to check the criteria and each and
every time it had added an OR statement which makes my initial criteria
pointless.

i.e. my criteria a
1) letter number = "1"
AND 2) Country isblank
AND 3) Title = "Magazine1"

and i come back and it has
1) letter number = "1"
AND 2) Country isblank
OR 3) Country isblank
AND 3) Title = "Magazine1"
..

WHY o why is it doing this to me?

 
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
merge query criteria error bugs !!! K.C. Ho Mailmerge 1 August 31st 06 11:40 AM
merge word with an access query with a like criteria Salli Mailmerge 1 December 1st 05 10:35 PM
Print a mail merge recipients LIST sao Mailmerge 1 May 13th 05 06:30 AM
what if the button "Mail Merge Recipients" responds to data lost B Ikard Mailmerge 1 April 15th 05 10:24 PM
Printing a list of recipients from a mail merge list Kathryn at GJS Microsoft Word Help 1 March 9th 05 04:34 PM


All times are GMT +1. The time now is 11:56 PM.

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

About Us

"It's about Microsoft Word"