Merge pop up box

[John]

I am using Office 2000 with Windows XP.

I have a database set up in Excel (2000) and several form files setup in
Word (2000).

I need only one merge file at a time. Currently, I select the form file I
want to use, go to Tools Mail Merge, Query, type in the name of the file I
want, choose Merge.

I need to automate this funtion.

This is way to many steps. What I want a box that pops up immediately upon
opening the form file that asks me for the first and last name (file from
excel database)and auto locates that file from the database and merges all in
one step after I type in the first and last name in the box.

Is that to much to ask? I am fairly new so specifics would help. I have
some macro, bookmark and ref, text box experience. But be gentle!

Thank you for your help.

John

 

[Perry]

You are in need of some direct Ecxel/Word interop/automation code
Here are some links that can change yr approach to wire data from Excel to
Word

http://word.mvps.org/FAQs/InterDev/ControlWordFromXL.htm

http://word.mvps.org/FAQs/InterDev/FillListBoxFromXLDAO.htm

 

[John]

Thank you so much. I will check out your links.

John

 

[John]

Okay. I took a look at the links. I think I need to post to the other
discussion groups as this is a bit over my head.

I need to start with the basics and work up to this.

Thank you very much for your help. Once I figure out how to read some of
the code I will give this a try.

I appreciate your help.

John