Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / March 2005

Tip: Looking for answers? Try searching our database.

how do i set up mail merge to acces queries in office 2000

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Tiani - 10 Mar 2005 01:09 GMT
I am trying to set up a mail merge in word 2000 to an acces database, however
word is not showing all queries.

do you know how to show all queries so that i can set up the mail merge

Thanks
Tiani
Peter Jamieson - 10 Mar 2005 15:29 GMT
Normally you see all the queries, especially when you connect from Word
using the default mechanism (DDE), which opens a copy of Access.

However, it is possible that the queries have been inserted in a way that
makes them invisible to Word, or that someone has marked them as Hidden in
the Properties for the query in Access, or that the database uses workgroup
security and the queries are not visible to the default user ("Admin"). Or
maybe there is something else you can see that is special about the hidden
queries? If you are allowed to add material to this database, you might be
able to work around this problem by adding new queries that simply do

SELECT * FROM queryname

for each query you cannot see.

Peter Jamieson

>I am trying to set up a mail merge in word 2000 to an acces database,
>however
[quoted text clipped - 4 lines]
> Thanks
> Tiani
tweetyangel - 15 Mar 2005 22:05 GMT
I am having the same problem.  Any query that contains a prompt as a
condition does not show up anymore.  The only way to get them to show up is
to remove the prompt, this causes the users of mail merge to have to edit the
recipient list and limit the data in Word instead of in Access.  This is
horrible!

> Normally you see all the queries, especially when you connect from Word
> using the default mechanism (DDE), which opens a copy of Access.
[quoted text clipped - 21 lines]
> > Thanks
> > Tiani
tweetyangel - 15 Mar 2005 22:17 GMT
I just found another post that tells you how to work around this... awesome!!!
"From the Tools menu, select Options and then go to the General tab and check
the "Confirm conversions at open" item.  Then try the other methods of
connecting to the data source that will become available to you."

> I am having the same problem.  Any query that contains a prompt as a
> condition does not show up anymore.  The only way to get them to show up is
[quoted text clipped - 27 lines]
> > > Thanks
> > > Tiani

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.