Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Advanced Filter Won't Unfilter
Hi, using Mail merge to query a view on a MSSQL server. the advanced
filter works fine. Do the mail merge and no problem. Back to the main merge document, i want to change the filter, but the filtered data is still there, and i can only filter the filtered data =S To get back to showing all of the data, i have to re-open the connection file to get the data back... So, is there a way to make the filter un filter itself? without having to re-open the connection? Thanks |
#2
|
|||
|
|||
Yes, this is an irritating problem.
As far as I know, all you can do is a. change the filter to one that includes everything (e.g. if you are filtering on Country, Country '' might get you all the records back, but there will still be a filter, which may for example affect performance or result in records with null values being excluded. b. go into the VBA Editor and, for example, use the Immediate Window to set, for example ActiveDocument.MailMerge.DataSource.QueryString = "SELECT * FROM ""tablename""" However, that's probably harder than going through the connection process again. Peter Jamieson "Nucleo" wrote in message oups.com... Hi, using Mail merge to query a view on a MSSQL server. the advanced filter works fine. Do the mail merge and no problem. Back to the main merge document, i want to change the filter, but the filtered data is still there, and i can only filter the filtered data =S To get back to showing all of the data, i have to re-open the connection file to get the data back... So, is there a way to make the filter un filter itself? without having to re-open the connection? Thanks |
#3
|
|||
|
|||
your probably right =)
i think i will stick with just re-opening the connection. with any luck, the client will only use the mail merge doc, then close it, then re-open later. thanks for the heads up Nuc |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need DXF filter for Office 2000, Word | Microsoft Word Help | |||
I need information on Filter Keys. | Microsoft Word Help | |||
How do I filter a Dbase date field in a word mail merge documnet? | Mailmerge | |||
The message filter indicated that the application is busy. | Mailmerge | |||
How to filter out adreses from Outlook that don't have certian fie | Mailmerge |