Link to home
Start Free TrialLog in
Avatar of darls15
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
ASKER CERTIFIED SOLUTION
Avatar of omgang
omgang
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of darls15
darls15

ASKER

thanks for you help,
darls15