running word macro from access DB

[Reesey]

I have a macro all set up to run a mail merge against my query in access--I want to be able to stay in by db and run the macro...I thought I could use a blank form,create a command button,choose run application as the command and then I would have to choose the macro name with the browse button--I wasnt sure if this would work but I dont even know where to find the macro i saved--word auto saved it obviously somewhere. I thought if I could input the path ie crofiles\program files\microsoft\macros\macro1 that it would work just the same as if I went into word and chose tools>run macro>macro 1

 

[Jim/Chris]

In a macro use the RunApp command opening your wor
document. Create a macro in word naming it AutoNew which
auto matically executes when document is opened. See help
in word for this. Watch for wordwrap
Macro command
RunApp
Command Line
"C:\PathTowinword\winword.exe"
"C:\PathTodocument\documentname.doc"

-----Original Message-----
I have a macro all set up to run a mail merge against my

query in access--I want to be able to stay in by db and run
the macro...I thought I could use a blank form,create a
command button,choose run application as the command and
then I would have to choose the macro name with the browse
button--I wasnt sure if this would work but I dont even
know where to find the macro i saved--word auto saved it
obviously somewhere. I thought if I could input the path ie
crofiles\program files\microsoft\macros\macro1 that it
would work just the same as if I went into word and chose
tools>run macro>macro 1