Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 539
  • Last Modified:

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
0
DMurray
Asked:
DMurray
1 Solution
 
DMurrayAuthor Commented:
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.

0
 
DarthModCommented:
PAQed with points refunded (500)

DarthMod
Community Support Moderator
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now