DDESend or an alternative

  • Thread starter Thread starter Mike375
  • Start date Start date
M

Mike375

Guest
I want to be able to use something like DDESend for putting data into word bookmarks. I already have several instances where this is done with code but I need some others with a simple thing like DDESend.

The problem I have with DDESend is when the form opens a box pops up asking if the Word file is to be opened. I tried with code to first open the Word.doc file and then have the code open the form with the DDESend text boxes but that ends opening two instances of the same Word.doc and the screen all quivers:D

If I just open the form in question and then click OK to open the Word.doc, then close and reopen the form (but without closing the Word.doc, just shrinking it) then all is well. But it is not practical to do that for what is wanted.

Any ideas or an alternative to DDESend. An alternative would need to be simple like a DDESend in text box as it requires someone to be able to easily change field references.
 
Look at the mail merge with Word feature in Access.
 
Never thought of it:)

Do you know if the mail merge with Access would allow for the Word.doc to be copied and closed. I guess that would only requite code to reopen the Word.doc and copy?
 

Users who are viewing this thread

Back
Top Bottom