Starting the merge from Access I get as far as opening the existing Word document. When this is open a "confirm datasource" dialogue box opens with one choice in it - OLE DB database files. Clicking OK on this brings up a "mail merge wizard" error box saying "Word was unable to open the data source".
I have found a "work-around" for this which obviously should not be becessary. The work around is as follows.
In the "confirm datasource" dialogue box I check the "show all" box and choose the MS Access Database via ODBC (*.mdb,accdb). This gives me an error box "ODBC Microsoft Access Driver Login Failed" and tells me it "could not find file c:\documents and settings\dave.jones\my documents.mdb". This is not the name of my database!. I OK the error and it brings up a login box where I click the database button and choose the right database. This gives me a "select database" dialogue box which again has the wrong database selected. Changing this to the correct database from the dropdown box and then clicking "options" and checking all four boxes finally allows me to select the query I need.
From here the mail merge works OK.
Starting the mail merge from Word gives the same result.
I have duplicated this on three computers but a web search has not found anyone else with the problem.
Can anyone help please?
I have found a "work-around" for this which obviously should not be becessary. The work around is as follows.
In the "confirm datasource" dialogue box I check the "show all" box and choose the MS Access Database via ODBC (*.mdb,accdb). This gives me an error box "ODBC Microsoft Access Driver Login Failed" and tells me it "could not find file c:\documents and settings\dave.jones\my documents.mdb". This is not the name of my database!. I OK the error and it brings up a login box where I click the database button and choose the right database. This gives me a "select database" dialogue box which again has the wrong database selected. Changing this to the correct database from the dropdown box and then clicking "options" and checking all four boxes finally allows me to select the query I need.
From here the mail merge works OK.
Starting the mail merge from Word gives the same result.
I have duplicated this on three computers but a web search has not found anyone else with the problem.
Can anyone help please?