VBA Mail merge word with data from excel.

[joepublic]

Hello
I am newbie with this VBA.
I am trying to merge my excel data into word all with VBA.
My word and excel version is 2000 9.0.2812
Please would you help me? I really apreciate any help !!.

I will explain in detail my needs.
I have a big excel table with data.
When I open this excel file and I select any cell from row 2, or row 3, or row 4 and press the macro "Ctrl+5" it should merge all the data from this row into a specific template of word which name and location is in column C, and this word document would be displayed on the screen to modify or print it.
I just need to display my report in word with the excel data FOR just ONE SINGLE ROW. That's all.


IN THE Excell file I have this table:
Column A B C
Row2 Jose Martinez C:\test1.doc
Row3 Paula Perez C:\test2.doc
Row4 Celia Rodriguez C:\test3.doc

So if I have selected any column of row 2 the data to be merged is just the data in row 2 into my template test2.doc.
If I have selected any column of row 3, the data to be merger is just the data in row 3 and so on.....

I also need to know what kind of libraries must be activated from Visual basic panel.

Please, would anyone help me ?
Thanks a lot.
JOEY.