Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Edit Recipients & Blank Fields
I am using Word to generate labels from an Excel datasource which I have done
successfully before. This time I would like to filter about 5,000 records to print only customers in County Durham with a Yes in the Catalogue column and a blank entry under the Account No. column. I can edit to show only County Durham customers and County Durham customers with a Yes, but when I try and filter out those customers with an entry in the Account No. column it all goes wrong! It seems to ignore the filter and shows all customers. I have tried clicking on the arrows in the column headers and clicking on (Blanks), I have also tried clicking on Advanced and entering my criteria here. What is really odd is that when I try to get the blanks up, when I look in Advanced it duplicates the blank criteria and I can have two or three or four lines with it saying Account is blank and usually its got an OR in there too which could be the cause for confusion but I don't know why its doing it! Any ideas as I am now completely stuck?! |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Edit Recipients & Blank Fields
Yes, there are problems in this area, and Word gets the query criteria wrong
as you have noticed. In this case it is probably worth trying to reconnect using DDE, assuming you have Excel on your system (check Word Tools|Options|General|"Confirm conversions at open", then go through the process of selecting your data source again). Word will probably make a better job of generating the correct query from your Advanced options if you do that. Otherwise, do you also have Access? Peter Jamieson "Ruth" wrote in message ... I am using Word to generate labels from an Excel datasource which I have done successfully before. This time I would like to filter about 5,000 records to print only customers in County Durham with a Yes in the Catalogue column and a blank entry under the Account No. column. I can edit to show only County Durham customers and County Durham customers with a Yes, but when I try and filter out those customers with an entry in the Account No. column it all goes wrong! It seems to ignore the filter and shows all customers. I have tried clicking on the arrows in the column headers and clicking on (Blanks), I have also tried clicking on Advanced and entering my criteria here. What is really odd is that when I try to get the blanks up, when I look in Advanced it duplicates the blank criteria and I can have two or three or four lines with it saying Account is blank and usually its got an OR in there too which could be the cause for confusion but I don't know why its doing it! Any ideas as I am now completely stuck?! |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Edit Recipients & Blank Fields
Why wasn't this problem fixed in office 2007?
"Peter Jamieson" wrote: Yes, there are problems in this area, and Word gets the query criteria wrong as you have noticed. In this case it is probably worth trying to reconnect using DDE, assuming you have Excel on your system (check Word Tools|Options|General|"Confirm conversions at open", then go through the process of selecting your data source again). Word will probably make a better job of generating the correct query from your Advanced options if you do that. Otherwise, do you also have Access? Peter Jamieson "Ruth" wrote in message ... I am using Word to generate labels from an Excel datasource which I have done successfully before. This time I would like to filter about 5,000 records to print only customers in County Durham with a Yes in the Catalogue column and a blank entry under the Account No. column. I can edit to show only County Durham customers and County Durham customers with a Yes, but when I try and filter out those customers with an entry in the Account No. column it all goes wrong! It seems to ignore the filter and shows all customers. I have tried clicking on the arrows in the column headers and clicking on (Blanks), I have also tried clicking on Advanced and entering my criteria here. What is really odd is that when I try to get the blanks up, when I look in Advanced it duplicates the blank criteria and I can have two or three or four lines with it saying Account is blank and usually its got an OR in there too which could be the cause for confusion but I don't know why its doing it! Any ideas as I am now completely stuck?! |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Edit Recipients & Blank Fields
For "why" questions, you really have to
a. come to your own conclusions as to what a commercial organisation is likely to focus on when producing a new release b. ask the authors. Personally, as far as (a) is concerned, I would rather commercial organisations focussed on fixing known problems, but that doesn't seem to be how it is and (b) I am just a volunteer. Peter Jamieson "KimC" wrote in message ... Why wasn't this problem fixed in office 2007? "Peter Jamieson" wrote: Yes, there are problems in this area, and Word gets the query criteria wrong as you have noticed. In this case it is probably worth trying to reconnect using DDE, assuming you have Excel on your system (check Word Tools|Options|General|"Confirm conversions at open", then go through the process of selecting your data source again). Word will probably make a better job of generating the correct query from your Advanced options if you do that. Otherwise, do you also have Access? Peter Jamieson "Ruth" wrote in message ... I am using Word to generate labels from an Excel datasource which I have done successfully before. This time I would like to filter about 5,000 records to print only customers in County Durham with a Yes in the Catalogue column and a blank entry under the Account No. column. I can edit to show only County Durham customers and County Durham customers with a Yes, but when I try and filter out those customers with an entry in the Account No. column it all goes wrong! It seems to ignore the filter and shows all customers. I have tried clicking on the arrows in the column headers and clicking on (Blanks), I have also tried clicking on Advanced and entering my criteria here. What is really odd is that when I try to get the blanks up, when I look in Advanced it duplicates the blank criteria and I can have two or three or four lines with it saying Account is blank and usually its got an OR in there too which could be the cause for confusion but I don't know why its doing it! Any ideas as I am now completely stuck?! |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
building a form with a table and edit fields | Tables | |||
W-2003 Mail merge - Recipients/Edit/Customize - viewing pane (pain | Mailmerge | |||
Merged Document edit fields MS Word 2003 SP1 | Mailmerge | |||
I can't edit mail merge recipients (edit "greyed out") | Mailmerge | |||
I can't edit mail merge recipients - edit is "greyed out" | Mailmerge |