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
darls15Asked:
Who is Participating?
 
omgangConnect With a Mentor Commented:
On your computer, temporarily unmap drive letter G.  In the Word mail-merge setup point to the Access .accdb file using a unc path instead of a drive letter mapping, e.g. \\TheFileServer\TheShare\Projects\Example.accdb.

Once you've dont the above you can remap drive letter G on your computer.  All client computers will understand the unc path and be able to find the Access db as long as they have sufficient permissions to do so.

OM Gang
0
 
darls15Author Commented:
thanks for you help,
darls15
0
All Courses

From novice to tech pro — start learning today.