Using Access2000 data source

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Leslie Isaacs - 15 Sep 2006 10:54 GMT

Hello All

I have a document in Word2003 that I want to do a mail merge with, using an
Access2000 mdb as data source. The problem is that I seem to be unable to
use a query from the mdb - only a table. I don't know whether this is
because of a Word2003/Access2000 incompatibility, or something else - but
surely I'm not trying to do the impossible?

Hope someone can help.
Many thanks
Leslie Isaacs

Reply to this Message

Doug Robbins - Word MVP - 15 Sep 2006 12:30 GMT

It may be an issue with the way that the connection is being made to the
data source. From the Tools menu in Word, select Options and then go to the
General tab and check the box against the item "Confirm conversions at
open." Then when you attach the data source to the mailmerge main document,
you will be presented with a dialog in which you can select the method by
which the attachment should be made. Try the DDE option.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> Hello All
>
[quoted text clipped - 7 lines]
> Many thanks
> Leslie Isaacs

Reply to this Message

Leslie Isaacs - 15 Sep 2006 15:13 GMT

Doug
Aren't these newsgroups great!
I did as you suggested and immediately I was presented with the option of
selecting a query as data source!
Many thanks.
Les

> It may be an issue with the way that the connection is being made to the
> data source. From the Tools menu in Word, select Options and then go to
[quoted text clipped - 14 lines]
>> Many thanks
>> Leslie Isaacs

Reply to this Message

Cindy M. - 15 Sep 2006 14:32 GMT

Hi Leslie,

> I have a document in Word2003 that I want to do a mail merge with, using an
> Access2000 mdb as data source. The problem is that I seem to be unable to
> use a query from the mdb - only a table. I don't know whether this is
> because of a Word2003/Access2000 incompatibility, or something else - but
> surely I'm not trying to do the impossible?

Hmmm. DDE usually only works between Word+Access from the same version of
Office. You can try Doug's suggestion, but I don't think it will work.

However, if these queries use any wildcards (* or ?), then you're likely
running into a conflict between the default OLE DB connection in Word 2003
(uses the ANSI-92 query syntax) and the Access 2000 reliance on ANSI-89.
Follow the steps Doug outlines, but choose the ODBC connection method.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail :-)

Reply to this Message