Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
merge query criteria error bugs !!!
I find a bug in office 2003,
When I am using Word 2003 to have a merging with Excel 2003, I selected 2 criteria, "Date" = "0829", and "Eng_verison" is blank (or is not equal "YES") It is no problem after the filter runs, the little excel show perfect information i need. The total no. of record is about 300 which is i wanted. but when i press ok and wait the merging, the no. of record suddenly goes to 3000 and then i went back to check the filtering. Strange !! There are one more criteria that "Eng_version" is blank ! which means two of the same criteria !But it use a "OR" to link with my other criterias. It is so annoying that my main job in company is to merging letters. It may have to solve by upgrading by it is already office 2003. Could you please give me some other ways first ? |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
merge query criteria error bugs !!!
You are correct that Word sometimes adds query criteria that should not be
there. You may find that changing the way that Word connects to Excel is enough: a. check Word Tools|Options|General|"Confirm conversions at open" b. go through the process of connecting to your spreadsheet again c. choose the DDE option when prompted. In this case, you will be connected to the first sheet in the workbook, or possibly the last sheet you had open. This may be enough because Word uses your filter criteria to build an SQL query, and it does this differently for different connection methods and data sources. Be aware that DDE is "deprecated" and ideally you would not have to use it. Unfortunately, there are so many problems in this area that it is still sometimes the best method to use. Another approach would be to set up a VBA routine to do the connection, and learn enough SQL to set up the criteria you want. Then you just change the SQL and run the routine. I can go through that if you want. Peter Jamieson "K.C. Ho" K.C. wrote in message ... I find a bug in office 2003, When I am using Word 2003 to have a merging with Excel 2003, I selected 2 criteria, "Date" = "0829", and "Eng_verison" is blank (or is not equal "YES") It is no problem after the filter runs, the little excel show perfect information i need. The total no. of record is about 300 which is i wanted. but when i press ok and wait the merging, the no. of record suddenly goes to 3000 and then i went back to check the filtering. Strange !! There are one more criteria that "Eng_version" is blank ! which means two of the same criteria !But it use a "OR" to link with my other criterias. It is so annoying that my main job in company is to merging letters. It may have to solve by upgrading by it is already office 2003. Could you please give me some other ways first ? |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mail merge using Access query problem | Mailmerge | |||
merge word with an access query with a like criteria | Mailmerge | |||
Mail Merge Access to Word using a Query | Mailmerge | |||
Can't Open Data Source (Query) where criteria is defined by functi | Mailmerge | |||
mail merge and access query | Mailmerge |