 |
 | 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 / August 2004Won't Find Table
I have a computer that I am trying to create a mail merger. The mail merger works on all of our other computers except these one. After I select the data file (an excel file), the window does not show any table to use. When I compare the macro code, the only thing I notice different is the Connection:= is"DNS=Excel Files; instead of the Connection:= "Provider=Microsoft.Jet.OLEDB.4.0;". The computers with the Microsoft.Jet.OLEDB work fine. How do I get the other computer to use Microsoft.Jet.OLEDB instead of DSN? Or this their something else causing my problem? Hi Jeff, which version of Word is installed on this "problem" machine? It sounds like the other machines certainly have Word 2002 or 2003 installed, where OLE DB is used for the connection by default. What you describe is an ODBC connection (which I usually prefer to OLE DB for Excel, BTW). That's not the default connection for Excel under ANY version of Word; prior to Word 2002 DDE was the default. Assuming this machine has the same version of Word as the other ones, then I'm guessing the OLE DB provider for Access/Excel is missing, which is why it's defaulting to ODBC. To get up and running immediately, you can certainly use the ODBC connection. What you need to do is click the "Options" button in the dialog box with that empty list (it would show named ranges), then activate all the checkboxes you find in the next dialog box (System Tables is the critical one). > I have a computer that I am trying to create a mail merger. The mail merger > works on all of our other computers except these one. After I select the [quoted text clipped - 3 lines] > "Provider=Microsoft.Jet.OLEDB.4.0;". The computers with the > Microsoft.Jet.OLEDB work fine. Cindy Meister INTER-Solutions, Switzerland http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004) 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 :-)
|
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.