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 / July 2006

Tip: Looking for answers? Try searching our database.

Merging data to word from access

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
GR - 07 Jul 2006 04:52 GMT
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 - 07 Jul 2006 11:01 GMT
> 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

>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
[quoted text clipped - 10 lines]
>
> Gwen
 
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.