Excel to Open Word

[jo15765]

I have this code that opens a word doc based on the value of a textbox...

Please Login or Register  to view this content.

This code works great to open the word doc specified, what I don't know how to do, is when the word doc opens, it runs a mail merge and asks for an input parameter from the query. How can I create a textbox on the same form that will pass the value to the parameter window that will open once word opens?