Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / October 2004

Tip: Looking for answers? Try searching our database.

access field

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Russ - 28 Oct 2004 19:01 GMT
Is it possible to use an ask function in a mail merge, and have the value
that is input be stored in an access database?

For example, when a record is viewed i want the question "What is Mr. Jone's
age?" to be asked, adn the answer "48" to be put into the access database
that mail merge is run from?

thanks for your help
Signature

Russ

Peter Jamieson - 28 Oct 2004 20:44 GMT
There is no "out-of-the-box" facility to do this, but if you are using Word
2002 or later you should be able to do it using VBA, using Word's Mailmerge
events. I cannot offer suitable code, but what you would need to do is trap
the "before record merge" event, then in the VBA code for the event:
a. determine which record you are processing
b. prompt for the data you want to insert
c. use ADO or DAO (say) to modify the appropriate record in the Access
database.

You might also need to ensure that when Word opens Access as a data source,
it does not open it for exclusive access.

Peter Jamieson

> Is it possible to use an ask function in a mail merge, and have the value
> that is input be stored in an access database?
[quoted text clipped - 5 lines]
>
> thanks for your help
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.