Auto input to Word from Excel

[John]

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

 

[Charles Kenyon]

Application.Dialogs(wdDialogMailMergeFindRecipient).Show

I put the above in my AutoNew procedure (at the end).
--
Charles Kenyon

Word New User FAQ & Web Directory: http://addbalance.com/word

Intermediate User's Guide to Microsoft Word (supplemented version of
Microsoft's Legal Users' Guide) http://addbalance.com/usersguide


--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.

 

[John]

Thank you. I will give that a try.
--
John R.

Application.Dialogs(wdDialogMailMergeFindRecipient).Show

I put the above in my AutoNew procedure (at the end).
--
Charles Kenyon

Word New User FAQ & Web Directory: http://addbalance.com/word

Intermediate User's Guide to Microsoft Word (supplemented version of
Microsoft's Legal Users' Guide) http://addbalance.com/usersguide


--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.