Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Setting a default datasource location
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. |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Setting a default datasource location
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. |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Setting a default datasource location
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. |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Setting a default datasource location
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. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Setting default headers and fonts in a template | Microsoft Word Help | |||
Changing default Datasource location | Mailmerge | |||
How do I restore the DEFAULT file location for clipart in Word? | Microsoft Word Help | |||
how to reset to default (blank out) the clipart file location in . | Microsoft Word Help | |||
Default font - possible bulletproof fix in Word 2003 | Microsoft Word Help |