darls15
asked on
Linking a Word mail merge document to an Access query for users with differently mapped drives
Hi Experts
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
darls15
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
darls15
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
darls15