merge no longer selects & sorts records

  • Thread starter Thread starter BillG
  • Start date Start date
B

BillG

I recently changed the contract I work on/for, and last week this included a
new computer. Previously our C-drives had a "D" partition for non-OS data,
but the new world we are in does not, so all data is now on "C". At the
same, although we continue to use XPPro, we were upgraded to Office 2007.

Now, with that in mind, here is my situation. All of my WORD documents
merge from a single Excel database, and they all think it is still on "D".
When opening the document fails because the Excel file cannot be found on
"D", I can point it to the new "C" location, but it won't continue to look
there the next time I open it (even when re-Saved) and even when I do point
it there none of the record select/sort criteris work any more. Instead, I
get all records in whatever order the appear in the Excel database.

So I have two questions:
1- how can I change where the WORD document looks for the Excel file?
2- how can I make my record select/sort criteria work?
 
I have an update. It very much looks like the last step in the Merge
process, when queried for the which records to use (all, or current, or a
range) answering "all" as has always been done will now actually give you ALL
records, rather than all records that the search/sort criteria have winnowed
me down to.
 
Lack of response here gives me a very bad feeling.

In the mean while, I have continued to pursue the question, and have
discovered that, even though opening the document TELLS me that it will
perform the SQL that will select&sort, in fact when you edit the recipients
they are all there AND the select&sort criteria are both completely empty --
which, of course, explains why all
records are merged in their original unsorted order.

So the questions continue:
1- how do I make the new location of the database permanent
2- what is happening to my select/sort criteria, and what can I do about it
 
BillG said:
Lack of response here gives me a very bad feeling.

In the meanwhile, I have continued to pursue the question, and have
discovered that, even though opening the document TELLS me that it will
perform the SQL that will select & sort, in fact when you edit the recipients
they are all there AND the select & sort criteria are both completely empty --
which, of course, explains why all
records are merged in their original unsorted order.

So the questions continue:
1- How do I make the new location of the database permanent?
2- What is happening to my select/sort criteria, and what can I do about it?
Click to expand...

Try an Office group where SQL, Office and Excel are spoken fluently.
 
Back
Top