Hi

I'm using 'Word 2003'.

I have set up a master mailmerge letter document, say
'masterletter.doc' which gets its data from 'mydata.doc'.

When I open 'masterletter.doc' it displays a dialog saying:

================================================== ===========================
Opening this document will run the following SQL cmmand:

SELECT * FROM C:\Documents and Settings\pat\My Documents\mydata.doc

Data from your database will be placed in the document do you want to
continue?
================================================== ===========================

If I click 'Yes' the data is merged - no problem provided that
'mydata.doc' is in 'C:\Documents and Settings\pat\My Documents\'.

My issue is that 'mydata.doc' and 'masterletter.doc' will not always
be in the folder 'C:\Documents and Settings\pat\My Documents\', but
they *will* always be in the same folder as each other.

So I want the master mailmerge letter document to remember that the
data is in 'mydata.doc', which is to be found in the same folder as
''masterletter.doc'

I can't see a way of doing this via the mailmerge wizard.

Is there any way of specifying the location of the source data with
just file name rather than path + file name?

Thanks
Pat