Opening Mail Merge documents from Access

[Chris Burke]

Hi!

I have a query regarding the use of MS Word's Mail Merge
option when accessing an Access database.

I have database that contains member information that I
want to place in a MS Word letter. I have set up a mail
merge document in Word that uses my database as it's
source. The database has an button that when you click it
the Word document loads with the relevant data in. The
thing is that it actually opens a duplicate copy of the
database.

Is it possible to stop this happening and why doesn't word
recognise that the database is already open. I use a macro
to open the word document.

Thanks guys and gals!

 

[Chris burke]

Thanks!!!

-----Original Message-----
It happens because DDE (a very old technology)
looks for the Window Name ('Microsoft Access' ???)

You can avoid the problem by making sure that
your window name (application name) starts with
the expected words, or by using a different method
of linking to the database (ODBC) or by other methods
(a google search of this news group would find more
information)

(david)





.