Mailmerge data source in an Access database will not open

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Colin C - 22 Dec 2004 16:21 GMT

I am creating directory in Word 2003 by mailmerge using as the data source a
query in an Access database (prepared in Access 2003 but in 2000 format) .
When I attempt to browse to the data source I find that every table and query
is listed except the one I want.

Approaching the problem via Tools > Office Links etc in Access, the required
query is listed but draws the response " Can not open data source".

The only exceptional feature of the query i can see is that it contains a
number of calculated fields.

Reply to this Message

Doug Robbins - Word MVP - 23 Dec 2004 05:47 GMT

From the Tools menu in Word, select Options and then on the General tab,
check the box against the "Confirm conversions at open" item and then when
you attempt to attach the data source, you will be given a number of
different connection methods that you can try. One of them will probably
overcome your problem.

Signature

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP

> I am creating directory in Word 2003 by mailmerge using as the data source a
> query in an Access database (prepared in Access 2003 but in 2000 format) .
[quoted text clipped - 6 lines]
> The only exceptional feature of the query i can see is that it contains a
> number of calculated fields.

Reply to this Message

Colin C - 23 Dec 2004 10:09 GMT

Only a tiny step forward unfortunately. Your recommendation does at least
result in the data source being listed. The option"MS Access databases via
DDE" attempts to open the file but never completes the operation. Other
options get responses "Word can not open file" etc

Thanks for trying.

I would still like to know the answer but I have devised a slightly tedious
workaround by exporting the data from the query to a Word Merge file.

Colin C

> From the Tools menu in Word, select Options and then on the General tab,
> check the box against the "Confirm conversions at open" item and then when
[quoted text clipped - 15 lines]
> > The only exceptional feature of the query i can see is that it contains a
> > number of calculated fields.

Reply to this Message

Colin C - 31 Dec 2004 00:01 GMT

Thanks that seems to be the access to the solution.

Colin C

Reply to this Message

Rate this thread: