Merging data to word from access

[GR]

I don't know if anyone can help me? I am trying to merge some details from
an access query in to a word document. I select the source document and can
complete the merge successfully but when I save then exit, when I return in
to the document, it has not stored the source details and reverts to a
different table in my data source to the query specified.

Is there any way I can save the source that word should be pulling the
information from?

Kind Regards,

Gwen

 

[Peter Jamieson]

Is there any way I can save the source that word should be pulling the

information from?

It depends on exactly what you mean.
a. a Word mail merge main document that has been connected to a data source
such as an Access query, then saved, should reconnect to that query when you
re-open the document, although you may see a question about executing SQL.
b. When it reconnects, the query should execute, i.e. you should see the
data that the query returns /now/, not the data that the query returned when
you last did the merge.
c. in some cases, Word 2002 (and possibly 2003) does not successfully
reconnect to the query, e.g. if you have applied additional selection
criteria you may experience some problems

So...
d. which version of Word/Access?
e. can you spell out /exactly/ what steps you are taking?
f. in particular, are you definitely saving the Word mail merge main
document after you have attached it to your query data source
g. when you re-open that document, do you see any messages? If so, what are
they?

Peter Jamieson