Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
John
 
Posts: n/a
Default Auto input to Word from Excel

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

  #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




  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
John
 
Posts: n/a
Default Auto input to Word from Excel

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


"Charles Kenyon" wrote:

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





Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Word 97 in Windows XP to maintain formatting Charlie''s Word VBA questions Microsoft Word Help 22 May 20th 23 08:51 PM
Word should allow to 'divide' page by 3 or 4, not just 2 CandasK Page Layout 2 February 28th 06 10:16 PM
Does Word have a QuickCorrect/Quick Word option like WordPerfect? CW New Users 2 December 20th 05 05:54 PM
In Word, how do I surpress headers and footers on page 2 Bill Microsoft Word Help 1 December 15th 05 06:13 PM
Envelope Address GR New Users 5 April 24th 05 09:48 PM


All times are GMT +1. The time now is 04:27 AM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"