View Single Post
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Charles Kenyon
 
Posts: n/a
Default Auto input to Word from Excel

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

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.


"John" wrote in message
...
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