Auto input to Word from Excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

John - 31 Mar 2006 21:39 GMT

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

Reply to this Message

Charles Kenyon - 01 Apr 2006 00:15 GMT

Application.Dialogs(wdDialogMailMergeFindRecipient).Show

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

Signature

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

See also the MVP FAQ: http://word.mvps.org/FAQs/ which is awesome!
--------- --------- --------- --------- --------- ---------
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.

>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.
[quoted text clipped - 20 lines]
> Thank you,
> John

Reply to this Message

John - 03 Apr 2006 17:54 GMT

Thank you. I will give that a try.

Signature

John R.

> Application.Dialogs(wdDialogMailMergeFindRecipient).Show
>
[quoted text clipped - 23 lines]
> > Thank you,
> > John

Reply to this Message