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.

Ok - did some experimenting and reading, it appears that My Documents is the
user's default folder
and the mailmerge documents seem to be finding their datasource (on my home
PC ) when both the source file and merge file are in My documents.
would i be correct in assuming that this would work for any user as long as
the source file and merge document are in his/her 'My Documents' folder?

"Junior" wrote in message
...
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.

If the merge documents are in the same folder as their data sources the
merge documents should find their data files without further interference
(provided there is not a file of similar name in the c:\MyFolder folder).

As for the INCLUDETEXT field - remove the path from the filename and if that
document is in the same folder as the merge document it will find that too,

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



Junior wrote:
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.

Graham - Great news - that makes this change alot easier
thanks for your help


"Graham Mayor" wrote in message
...
If the merge documents are in the same folder as their data sources the
merge documents should find their data files without further interference
(provided there is not a file of similar name in the c:\MyFolder folder).

As for the INCLUDETEXT field - remove the path from the filename and if
that document is in the same folder as the merge document it will find
that too,

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



Junior wrote:
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.