Merge from Access to Word - Loses Data Source

[Williams]

I have a Microsoft Word Mail Merge document that uses a Microsoft Access
query as the data source. A DSN has been setup for the connection. The user
clicks a command button and the MS Word Mail Merge document is suppose to
appear ready complete the merge. The process usually works great but lately
the MS Document seems to be losing the link and needs help to find the data
source. Any ideas? Why would this work one day and then the next it needs
help re-finding the data source?

 

[a a r o n . k e m p f]

I just use SQL Server Reporting Services to export my reports to Word,
and then the users can edit the document in word before sending.

it's a _VERY_ flexible and beautiful platform

Thanks

-Aaron

 

[Mark Andrews]

I would try
http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html
it's a good way to do word merging.