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.

Mailmerge in Word (Datasource: Access)

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
GA - 11 Oct 2004 15:11 GMT
Hi,
Thank you ever so much for your prompt reply.
From what I've understood, the issue is not in creating
300 different word documents("sub-doc.") (which is the
individual student records) from the Master/Main
mailmerge doc. But the problem arises when, once I have
set up these "sub-doc." (created by executing the main
mail merge doc.) and I subsequently, update the fields in
my datasource (eg Access), the SUB-DOC.  does not pick up
the changes made in my datasource.

1) Can I run a Macro in my sub-doc. to reflect the
changes made in datasource at periodic intervals?

2) Other than creating a form/report on Access, is there
another application which I can use, which works on a
real-time basis. Thank you for your advice. GA
Doug Robbins - 11 Oct 2004 16:30 GMT
Once you execute the merge, there is no link between the document that is
created that contains a "sub-doc" for each student and the original data
source.  If changes are made to the datasource, it is necessary to
re-execute the merge for those changes to be reflected in the "sub-docs".
Of course, if the individual "sub-docs" have been modified in any way, those
modifications will not appear in the new document (containing a new set of
sub-docs) is created by executing the merge.

It is probably possible to create a macro to do what you suggest, but,
without wanting in any way to sound insulting, if you had the ability to
create that macro, you probably would not ask the question.  It would not be
a simple task.

I do not know of any other method of doing this.  I would do it all in
Access.

Signature

Please respond to the Newsgroup for the benefit of others who may be
interested.   Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP

> Hi,
> Thank you ever so much for your prompt reply.
[quoted text clipped - 13 lines]
> another application which I can use, which works on a
> real-time basis. Thank you for your advice. GA
 
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.