Hi, thanks for the quick reply. We do execute the merge as we run a query in word (selecting the client ref) then hit merge and merge to a new document but it still retains some sort of link to the datasource as it always askes for the database.
I have tried recreating the .dot template and the sql view, also the .mdb, tried various methods to connect word to the .mdb but still no joy.