Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
![]()
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 | |
|
|
![]() |
||||
Thread | Forum | |||
merge query criteria error bugs !!! | Mailmerge | |||
merge word with an access query with a like criteria | Mailmerge | |||
Print a mail merge recipients LIST | Mailmerge | |||
what if the button "Mail Merge Recipients" responds to data lost | Mailmerge | |||
Printing a list of recipients from a mail merge list | Microsoft Word Help |