Passing Parameters to Word 97 from Access 97! 
Author Message
 Passing Parameters to Word 97 from Access 97!

i'm using Access 97 - Word 97

i have a Mail Merge doc linked to my database.
I'd like to setup up some parameters in an admin form in the database.

like the Name and Location i'd like the newly created document to be stored.

currently i use an autoopen macro in word, but every time i want to rename
or save the document in a different location i have to go into the Mailmerge
template and change the Save As line in the autoopen macro.

Is it possible to pass this information to the autoopen macro directly from
Access 97!

Please Advise



Sun, 18 Jul 2004 17:25:34 GMT  
 Passing Parameters to Word 97 from Access 97!
I've managed to solve this.

it seems the best way is to create a word.application object, then any
macros can be created directly from whichever office application you like to
use as the controller.

it seems thought if there are any errors during the object creation, and the
code breaks while word is still invisible, the object remains open at the
stage it reached before breaking!

i think this is solved by added an On Error line to the code to delete the
object and clean up.


Mon, 19 Jul 2004 00:14:38 GMT  
 [ 2 post ] 

 Relevant Pages 

1. Help Needed - Passing Value from Access 97 to Word 97 Macro

2. Can you pass a table to Word 97 from Access 97

3. Passing Parameters to a Word 97 Macro from VB

4. Passing Report Parameters from VB6 to Access 97

5. Passing parameters to an Access 97 - query

6. Passing parameters to a stored query in Access 97

7. Passing Parameters to Access 97

8. Passing parameters to Access 97 reports

9. Access 97 create a Word 97 letter

10. MailMerge from Access 97 to Word 97, value lost

11. Word (97) constants in Access (97)

12. Automation seems to hang with Access 97 / Word 97


Powered by phpBB® Forum Software