Hello Reader;

I'm currently in the process of creating a database.

I have a Word Document that contains a Mail Merge. The data source for this
mail merge is an Access Database Query.

They are both stored within the same folder.

I want to distribute the Database with the Microsoft Word Mail Merge.

But I'm finding that when I move them, the Mail Merge is still trying to
look up data that is stored in the original location of the database.

Which, obviously when put on a different computer/network drive doesn't
work. I presumed that it would be dynamic but it remains static.

I've spoken to a Teacher of I.T and computing and they suggested using a dot
(.) and a backslash ( \ ) to make WORD look within the folder that the mail
merge is stored in, and to find the filename that follows eg.

..\Databasefile.mdb

When I add this in, it still doesn't work. It accepts this as a file name,
but still WORD looks for the original copy of the database when I'm
transporting it.

I COULD leave instructions for the end-user to update the file path of the
database, but as this database will be transported around quite a lot, this
will be a pain in the arse.

I'd really appreciate any help that you could give me,

Cheers in advance

Frustrated Dan