Access2K word 2K and 2K3
I developed an MSAccess program that creates txt files, sends them to
C:\Myfolder, then opens mailmerge documents
The mailmerge documents are also in C:\MyFolder and use the txt files as
their datasource.
We have been able to install all files on a New Users workstation in
C:\MyFolder and the mailmerge links remain intact.

Now, I have a delema because the network is changing and the Access program
and mailmerge documents will be moving to
C:\Documents and Settings\username\My Documents.
and the MSAccess program will be sending the datasource txt files to
C:\Documents and Settings\username\My Documents.

I know mailmerge Docs will open and ask the user to browse for the
datasource, but our users will not know how to do this.
Is there a way to instruct the Mailmerge documents (vba or macro) to find
the data source txt files at this new location?
Keeping in mind that the location will be dynamic - i.e. depends on the
username.

One more issue - one of the mailmerge documents has a paragraph that prints
a list based on below code.

{ INCLUDETEXT "C:\\MyFolder\\Missing.txt"  \* MERGEFORMAT}

Thanks of any help, advice.