Mailmerge in Word (Datasource: Access)

[GA]

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]

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.

--
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