Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how do i set up mail merge to acces queries in office 2000
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 |
#2
|
|||
|
|||
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 "Tiani" wrote in message ... 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 |
#3
|
|||
|
|||
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! "Peter Jamieson" wrote: 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 "Tiani" wrote in message ... 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 |
#4
|
|||
|
|||
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." "tweetyangel" wrote: 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! "Peter Jamieson" wrote: 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 "Tiani" wrote in message ... 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 |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mail Merge Word 2003 Issue | Mailmerge | |||
mail merge with attachments | Mailmerge | |||
Mail Merge Issue With Office 97 - Excel Data Source | Mailmerge | |||
Word-Excel 2003 - Mail Merge Recipients problem | Mailmerge | |||
Using Hyperlinks in Mail Merge IF...THEN...ELSE Statements | Mailmerge |