There are many examples of code on all three forums for automating Word from Excel and vice-versa. I suggest you do a search for some code you can adapt and, if you run into difficulties with the implementation, post back with the specifics.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]