Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Disconnecting DDE
I made an access application that saves a word document mailmerging
some filelds. It works properly. The matter is that i want to disconnect the dde connection: each time i open a saved word document, I don't want that access open itself again. So simply: is there any way to disconnect DDE links to a document (i think it is necessary operate into vba code, isn't it) ? thanks in advance for any reply. thanks in advance |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Disconnecting DDE
In general, I have found this: When using macros in Microsoft Access to
perform a mailmerge in Microsoft Word, it is not a good idea to connect the main (unmerged) Word document to the Access database as the data source. Instead, it's better to use the macros in Access to export the Access data to an RTF (rich-text format) file and then get the macros to perform the merge between the main (unmerged) Word document and the RTF file. This technique seems to avoid the problem of a second copy of Access opening when the merge is performed and then not being easily to close that second copy of Access. I'm not sure if this will help you. But your problem sounds perhaps similar. Geoff "Pit" wrote in message oups.com... I made an access application that saves a word document mailmerging some filelds. It works properly. The matter is that i want to disconnect the dde connection: each time i open a saved word document, I don't want that access open itself again. So simply: is there any way to disconnect DDE links to a document (i think it is necessary operate into vba code, isn't it) ? thanks in advance for any reply. thanks in advance |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Disconnecting links | Microsoft Word Help |