Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / June 2006

Tip: Looking for answers? Try searching our database.

Disconnecting DDE

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Pit - 15 Jun 2006 10:16 GMT
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
Geoff - 16 Jun 2006 22:49 GMT
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

>I made an access application that saves a word document mailmerging
> some filelds. It works properly. The matter is that i want to
[quoted text clipped - 3 lines]
> into vba code, isn't it)  ?
> thanks in advance for any reply. thanks in advance
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.