 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Mailmerge and Fax / December 2003Mail Merge from Query in Access - does not list all queries
When mail merging I use a query from an Access database.When I ask WORD to list the queries it only list around half the numbers, but all tables. Is there any way I can increase the listed number? - I have tried to make a new query - but it does not show either. Can anyone help me? Kjeld Andersen Hi K.S.Andersen, > When mail merging I use a query from an Access database.When I ask WORD to > list the queries it only list around half the numbers, but all tables. Is > there any way I can increase the listed number? - I have tried to make a new > query - but it does not show either. We need to know which VERSION of Word you're using? And was the database created in this version of Access, or an earlier one? 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 :-) Both programmes are version XP2002 K.S.Andersen "Cindy M -WordMVP-" <C.Meister-C@hispeed.ch> skrev i en meddelelse news:VA.00008cce.00fdcf09@speedy... > Hi K.S.Andersen, > [quoted text clipped - 13 lines] > This reply is posted in the Newsgroup; please post any follow question or > reply in the newsgroup and not by e-mail :-) Hi K.S.Andersen, > Both programmes are version XP2002 Have you seen Tom's response to you? Are these "problem" queries parameter queries, or just plain select queries? Go to my website and look in the Word 2002 section of the mail merge FAQ. You'll find information there about how to change the way Word links data in for mail merge. Try DDE or ODBC (instead of OLE DB, which Word 2002 is using by default). Cindy Meister  SignatureINTER-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 :-) I am using Office 2003. Word will not list any queries that are parameter queries. Check and see if the queries you are missing require the user to enter data before the query is run. Tom > When mail merging I use a query from an Access database.When I ask WORD to > list the queries it only list around half the numbers, but all tables. Is > there any way I can increase the listed number? - I have tried to make a new > query - but it does not show either. > Can anyone help me? > Kjeld Andersen Hi Tom, > I am using Office 2003. Word will not list any queries that are parameter > queries. Correct, using the default connection method. It will work using DDE, though (that's the only way to use them, as it starts up the Access interface). You'll find information on how to change the connection method 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 |
 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.