Merge from Access to Word - Loses Data Source

W

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Mail Merge using ACCESS 3
Mail Merge into Microsoft Word using Microsoft Access as data sour 3
Opening mail merge document from access 1
Can Access act as a 'multiple data source' for mail merge to Word? 3
Mail Merge doesn't update 1
Mail Merge with Word 3
Should I switch from Excel to Access as the data source 4
Access 2003 mail merge fails to recognise a mail merge document. 1

Top