Linking a Word mail merge document to an Access query for users with differently mapped drives
Posted on 2013-06-18
I have a MSWord document which I am trying to set up as a mail merge that will link to a MSAccess query to retrieve the data.
The merge works perfectly on my computer once I have linked to the query, however because other users have differently mapped drives it says it's unable to open the data source.
As an example, on my computer, to navigate to the query, the pathway is G:\Projects\Example.accdb and on another user's computer the pathway is A:\Projects\Example.accdb
Is there a way to get round this so that all users are able to open the document on their computer and run the mail merge?
Thanks in advance