DMurray
asked on
Mail Merge problems using Word 2003 and Access 2000
Hello Experts.
I'm encountering some serious problems trying to set Access 2000 querys (parameters and views) as data sources for my mail merge documents (Word 2003). After spending hours scouring the web for some existing help and coming up with nothing, its time to admit defeat and ask here !
Trying to set the data source to a preexisting query via DDE results in an 'Unable to establish DDE connection' - similar to the error described at http://support.microsoft.com/kb/813989/
Trying to set the data source to a preexisting query via ODBC results in a 'Word was unable to open the data source' - similar to the error described at http://support.microsoft.com/?kbid=888697
Despite the solutions proposed in both knowledge base arguments, I have no luck solving these problems. The ODBC method seems to work fine with Tables - however, not with Queries.
These mail merge documents worked fine in previous versions of word.
Help appreciated
DMurray
I'm encountering some serious problems trying to set Access 2000 querys (parameters and views) as data sources for my mail merge documents (Word 2003). After spending hours scouring the web for some existing help and coming up with nothing, its time to admit defeat and ask here !
Trying to set the data source to a preexisting query via DDE results in an 'Unable to establish DDE connection' - similar to the error described at http://support.microsoft.com/kb/813989/
Trying to set the data source to a preexisting query via ODBC results in a 'Word was unable to open the data source' - similar to the error described at http://support.microsoft.com/?kbid=888697
Despite the solutions proposed in both knowledge base arguments, I have no luck solving these problems. The ODBC method seems to work fine with Tables - however, not with Queries.
These mail merge documents worked fine in previous versions of word.
Help appreciated
DMurray
ASKER
Hello
The answer supplied did not solve my problem. I have since found a better solution utilising code from http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html.
I propose that this be deleted and points refunded.
Regards,
DMurray.
The answer supplied did not solve my problem. I have since found a better solution utilising code from http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html.
I propose that this be deleted and points refunded.
Regards,
DMurray.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
http://support.microsoft.com/ph/2509/en-us/?sid=54&aid=3&GSA_AC_More3
http://support.microsoft.com/ph/2530/en-us/?sid=47&aid=3&GSA_AC_More3
chk if it helps to solve ur problem.