Merge with query problem

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jordan - 07 Jan 2004 17:39 GMT

I'm running Office XP with a database that I created.
I'm trying to link my Word documents to a specific query
in the database. However, when I open the Mail Merge
Wizard in Word and bring up the list of Tables, only a
few of my queries are listed, mostly the ones that aren't
being used for documents. Why is it that some of my
queries show on this list, but not others?

Reply to this Message

Cindy M -WordMVP- - 07 Jan 2004 19:07 GMT

Hi Jordan,

> I'm running Office XP with a database that I created.
> I'm trying to link my Word documents to a specific query
[quoted text clipped - 3 lines]
> being used for documents. Why is it that some of my
> queries show on this list, but not others?

Sometimes, it depends on the type of query. Could you go to
one of the queries not listed, and look at it in the SQL
view? And copy the SQL to your reply, here?

You may also want to try connecting to Access using a
different (older) connection method than the new OLE DB
default. You'll find instructions for that in the Word 2002
section of my website's mail merge FAQ.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep
30 2003)
http://www.mvps.org/word

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

Tracy - 08 Jan 2004 14:17 GMT

I'm experiencing a similar problem. I want to link my word
doc to a specific query; however, when I use the wizard it
will only bring up a list of tables. I cannot find an
option to drill down to any of my queries. Any suggestions?

>-----Original Message-----
>I'm running Office XP with a database that I created.
[quoted text clipped - 5 lines]
>queries show on this list, but not others?
>.

Reply to this Message

Cindy M -WordMVP- - 08 Jan 2004 17:47 GMT

Hi Tracy,

> I'm experiencing a similar problem. I want to link my word
> doc to a specific query; however, when I use the wizard it
> will only bring up a list of tables. I cannot find an
> option to drill down to any of my queries.

May we assume you're using Word 2002? Or is it another
version? And the data source is Access? And are you choosing
a specific connection method, or using the default?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep
30 2003)
http://www.mvps.org/word

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