Mail Merge

B

bikerbabe

I have an application that needs to run 3 mail merges.
Right now the users are having trouble running it once I
create the mde and put it on the server. Do I need to go
to each workstation and make the connection to the mde
from their desktop?
 
A

Arvin Meyer

bikerbabe said:
I have an application that needs to run 3 mail merges.
Right now the users are having trouble running it once I
create the mde and put it on the server. Do I need to go
to each workstation and make the connection to the mde
from their desktop?
Click to expand...

If you were running a front-end on each desktop (as is the preferred
practice) and the data only on the server. You could set up each machine to
correctly run the merge. It's sometimes a bit more difficult to do it with
the query on the server since it will look to the C drive on its own machine
(which is now the server).

Try splitting the database and running it on each workstation. Also, earlier
versions of Office used DDE to make the connection from Word to the data.
Starting with Office XP, ODBC is used. Making the connection is a bit more
tenuous because of it.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access
 
Top