N
news.microsoft.com
Hello
this is maybe more a logistical question than a programming one
Current setup:
I have about 30 word documents set to merge data from an A2K3 export (rtf
format). This word docs have been stored locally on each users hard drive.
the button inside access exports the .rtf file with the customer info, opens
the word doc, and does a mail merge. works greeat. except, the users now
want to log in remotely to the server via rdp.
The problem:
so, how to make it so if the user is logged in to a local pc or thru rdp the
letters merge correctly?
First try:
put a copy of the letters on the server and created a flag in a table to
indicate whether or not they were locally logged in or remotely. if local,
export to local hard drive and open local doc (with mail merge already set
to the data source). same thing but if remote, opens a set of letters on
the server and exports to a folder on the server.
The next problem:
more than one user doing letters remotely locks the exported data file open
(and the letter). so, i thought to use the windows environmental variable
%HOMEDRIVE% to export and open a unique letter for each user - BUT - word
cant seem to use a variable for the location of mail-merge data.
any ideas?
thanks in advance
JamesSF
this is maybe more a logistical question than a programming one
Current setup:
I have about 30 word documents set to merge data from an A2K3 export (rtf
format). This word docs have been stored locally on each users hard drive.
the button inside access exports the .rtf file with the customer info, opens
the word doc, and does a mail merge. works greeat. except, the users now
want to log in remotely to the server via rdp.
The problem:
so, how to make it so if the user is logged in to a local pc or thru rdp the
letters merge correctly?
First try:
put a copy of the letters on the server and created a flag in a table to
indicate whether or not they were locally logged in or remotely. if local,
export to local hard drive and open local doc (with mail merge already set
to the data source). same thing but if remote, opens a set of letters on
the server and exports to a folder on the server.
The next problem:
more than one user doing letters remotely locks the exported data file open
(and the letter). so, i thought to use the windows environmental variable
%HOMEDRIVE% to export and open a unique letter for each user - BUT - word
cant seem to use a variable for the location of mail-merge data.
any ideas?
thanks in advance
JamesSF