Prev: Access 2007 w/VBA
Next: Why Access 2007 cuts off a inputed text description after saved?
From: Williams on 5 May 2010 12:47
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?
From: a a r o n . k e m p f on 6 May 2010 13:07
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





On May 5, 9:47 am, Williams <Willi...(a)discussions.microsoft.com>
wrote:
> 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?

From: Mark Andrews on 6 May 2010 17:38
I would try
http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html
it's a good way to do word merging.


--
Mark Andrews
RPT Software
http://www.rptsoftware.com
http://www.donationmanagementsoftware.com

"Williams" <Williams(a)discussions.microsoft.com> wrote in message
news:BAC8D042-A191-4259-9E8F-5DB6848000F2(a)microsoft.com...
> 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?

 | 
Pages: 1
Prev: Access 2007 w/VBA
Next: Why Access 2007 cuts off a inputed text description after saved?