I have a database constructed in Excel Office 2000. I have a form file
constructed that includes the merge codes from the database noted above. I
know how to do a basic merge.

What I want to construct from here is a user friendly inputbox that pops up
for the user while in the form file that asks that user to type in what file
they want retrieved from the excel database.

They type in the name, hit enter and the merge takes place accessing just
the one record requested into a new blank document.

Basically I want to shorten the steps to a basic mail merge and make the
form more efficient and faster to use for the other employees in my office.

Also, is there any way to make use of text boxes, list boxes and merge codes
all in one form?

Thank you,
John