Hello,

I wonder if anyone can help I have been using Access Queries in order to create merge letters in Word for years and now we have upgraded to Office 2003 everything seems to be going wrong. This is what I do:

1. Open a query in design view enter the relevant text in the appropriate field in order to select the records I want from the table, then I run it and the correct entries are there.

2. Open a standard letter in Word which was created and has been linked to the above mentioned query years ago.

This is where the problem starts in the past the letter opens up and the correct info is displayed so I go ahead and print. Now what is happening rather then linking to the query it is either displaying the last record that was used or nothing at all and in the record number box it says 0 when I know that there are several selected in the query.

I have tried re doing the merge setup and nothing happens the only way round it I have found is to merge it with the table rather then the query then using the Mail Merge Recipients Box you have to go through and reselect the records you want which is a pain as there are 945 records in the table.

Any ideas/help would be appreciated.

Thanks.

not a solution - but a get round

if your qry filters out what you want -
make anew table and append the data in it
merge to this table- (messy I know but its a get round and not the solution)
then delete