Merging with Access - query invisible

I've got a database with a variety of queries. I want to
do a mailmerge, but when I go to connect the list not all
of the queries are present. What would cause one query
not to show outside the database itself?

Hi Jeff,

I've got a database with a variety of queries. I want to
do a mailmerge, but when I go to connect the list not all
of the queries are present. What would cause one query
not to show outside the database itself?

The answer to this does depend on a certain extent to the
version of Office involved. Unfortunately, you don't mention
that...

The usual cause is that the type of query is not supported
by the selected mail merge connection method. Or permissions
are lacking (you're not the "owner", for example) so it's
excluded from the list.

If you tell us which version you're using, and go into the
SQL view of the query and copy/paste the SQL into your
reply, we may be able to give you a more accurate
explanation. (Or perhaps not, depending :-))

you might also try using a different connection method (DDE)
if this is Word 2002 or 2003. More information 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.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
:-)

Thanks for your response. I'm using 2003. I've tried
looking at what is different in the query that doesn't
show up in the list. I has a computed field, which the
others don't have. Certainly that wouldn't make it
incompatible with mail merge, would it?

Thanks again for your help.


-----Original Message-----
Hi Jeff,

I've got a database with a variety of queries. I want
to
do a mailmerge, but when I go to connect the list not
all
of the queries are present. What would cause one query
not to show outside the database itself?

The answer to this does depend on a certain extent to
the
version of Office involved. Unfortunately, you don't
mention
that...

The usual cause is that the type of query is not
supported
by the selected mail merge connection method. Or
permissions
are lacking (you're not the "owner", for example) so
it's
excluded from the list.

If you tell us which version you're using, and go into
the
SQL view of the query and copy/paste the SQL into your
reply, we may be able to give you a more accurate
explanation. (Or perhaps not, depending :-))

you might also try using a different connection method
(DDE)
if this is Word 2002 or 2003. More information 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.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
:-)

.

Hi Jeff,

Thanks for your response. I'm using 2003. I've tried
looking at what is different in the query that doesn't
show up in the list. I has a computed field, which the
others don't have. Certainly that wouldn't make it
incompatible with mail merge, would it?

Unfortunately, that is the case with the OLE DB default for
Word 2002/2003. You need to use DDE or ODBC, in this case.
How to do that is in website location mentioned in my last
posting.

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
:-)

Thanks a lot for your help. I'd have floundered with this
for a looooong time!

Best,
Jeff
-----Original Message-----
Hi Jeff,

Thanks for your response. I'm using 2003. I've tried
looking at what is different in the query that doesn't
show up in the list. I has a computed field, which the
others don't have. Certainly that wouldn't make it
incompatible with mail merge, would it?

Unfortunately, that is the case with the OLE DB default
for
Word 2002/2003. You need to use DDE or ODBC, in this
case.
How to do that is in website location mentioned in my
last
posting.

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
:-)

.

Cindy, the link on your website about using the old Mail
Merge Dialog Box is broken.

http://homepage.swissonline.ch/cindy...PrevVe02.htm#D
lgMHelp

Nancy

-----Original Message-----
Thanks a lot for your help. I'd have floundered with
this
for a looooong time!

Best,
Jeff
-----Original Message-----
Hi Jeff,

Thanks for your response. I'm using 2003. I've tried
looking at what is different in the query that
doesn't
show up in the list. I has a computed field, which
the
others don't have. Certainly that wouldn't make it
incompatible with mail merge, would it?

Unfortunately, that is the case with the OLE DB default
for
Word 2002/2003. You need to use DDE or ODBC, in this
case.
How to do that is in website location mentioned in my
last
posting.

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
:-)

.

.

-----Original Message-----
Thanks for your response. I'm using 2003. I've tried
looking at what is different in the query that doesn't
show up in the list. I has a computed field, which the
others don't have. Certainly that wouldn't make it
incompatible with mail merge, would it?

Thanks again for your help.


-----Original Message-----
Hi Jeff,

I've got a database with a variety of queries. I want
to
do a mailmerge, but when I go to connect the list not
all
of the queries are present. What would cause one query
not to show outside the database itself?

The answer to this does depend on a certain extent to
the
version of Office involved. Unfortunately, you don't
mention
that...

The usual cause is that the type of query is not
supported
by the selected mail merge connection method. Or
permissions
are lacking (you're not the "owner", for example) so
it's
excluded from the list.

If you tell us which version you're using, and go into
the
SQL view of the query and copy/paste the SQL into your
reply, we may be able to give you a more accurate
explanation. (Or perhaps not, depending :-))

you might also try using a different connection method
(DDE)
if this is Word 2002 or 2003. More information 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.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
:-)

.I am running into a similar problem. I will only see
the queries that do not use link tables. Any queries using
linked tables are invisible. This is true for the tables
themselves. Linked table invisible. I am using Word 2003
to merge with data from Access 97. When both products are
Office 97 this was not an issue. Help!

.