Using an access database as source data in word mailmerge

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

pat blakeley - 26 May 2004 15:20 GMT

I recently converted to Office XP. When I try to use my
Access database as the source document in my Word
mailmerge document, and go to browse to open the Access
database to use a query in that database as the source
dodument, it only lists 13 of the actual 25 queries that I
have saved in the Access database. The query that I want
to use does not appear in the list. In my previous Office
version, it would display ALL the queries in that
particular database. Anybody else out there encounte this
problem after converting to Word 2002 and Access 2002?

Reply to this Message

Cindy M -WordMVP- - 29 May 2004 17:26 GMT

Hi Pat,

The problem has come up various times, yes. The most
"obvious" reason would be that these are parameter queries?

If that's the case, then you need to use the old DDE
connection technology to use them with mail merge. You'll
find instructions for changing the connection method in the
Word 2002 section of my website's mail merge FAQ.

> I recently converted to Office XP. When I try to use my
> Access database as the source document in my Word
[quoted text clipped - 6 lines]
> particular database. Anybody else out there encounte this
> problem after converting to Word 2002 and Access 2002?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep
30 2003)
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

pat blakeley - 03 Jun 2004 23:41 GMT

I tried searching yur website for the DDE connection technology info but can't find anything. Can you please give me more specific info? I need to solve this problem ASAP.

Reply to this Message

Doug Robbins - Word MVP - 03 Jun 2004 23:48 GMT

Click on the "Mail merge in Word 2002" category and then under "Connection
methods", you will see "Connecting as in previous versions"

http://homepage.swissonline.ch/cindymeister/MergFram.htm

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 tried searching yur website for the DDE connection technology info but can't find anything. Can you please give me more specific info? I need to

solve this problem ASAP.

Reply to this Message