I've answered your other question. If you were to use something like that,
then define named ranges for the input areas, you could use something like
the macro below to send those values to Word:
http://vbaexpress.com/kb/getarticle.php?kb_id=381
************
Anne Troy
www.OfficeArticles.com

"gautam" wrote in message
...
Hi all,

I would like to know that can i make mail merger type of application in
Excel???

eg. I want to make one form for parameters of engine. Where i should
select
the engine from the drop down menu and all the parameters should be
entered
from an external database (can be other sheet of excel) in the specific
locations.

Prompt reply is appreciated.

Thanks

Gautam