meandmyhorse
New member
- Local time
- Today, 19:31
- Joined
- Jul 31, 2002
- Messages
- 6
Seems like everyone is trying to figure out how to automate mail merge from Access to Word.
I am one of those. I have very limited knowledge. I have gleamed all that I can from the board, and have just one last idea.
I can get on the click of a button Access to open Word and launch by form letter. But haven't been able to get mail merge to work.
I wrote a Macro in Word that works, but I can't figure out the code to type in Access that once it opens Word and the form letter to then run the macro in Word.
I did a docmd.runmacro "merge", but it is looking at Access for the macro and the macro is in Word.
There must be a way? I think I could make the macro run when the document is opened, but I would like to stay away from that if I can.
Any help would be appreciated. Thanks!
I am one of those. I have very limited knowledge. I have gleamed all that I can from the board, and have just one last idea.
I can get on the click of a button Access to open Word and launch by form letter. But haven't been able to get mail merge to work.
I wrote a Macro in Word that works, but I can't figure out the code to type in Access that once it opens Word and the form letter to then run the macro in Word.
I did a docmd.runmacro "merge", but it is looking at Access for the macro and the macro is in Word.
There must be a way? I think I could make the macro run when the document is opened, but I would like to stay away from that if I can.
Any help would be appreciated. Thanks!
