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 / July 2004

Tip: Looking for answers? Try searching our database.

Oracle, Word XP(mail merge)

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Parkite - 20 Jul 2004 16:34 GMT
Hello,

  We have a bunch of old Word docs that merges with an
Access database.  We are currently in the process of
converting them to Word XP and the data resides in
Oracle.  However, we are having problems converting
them.  We would create a new data source to point to the
database and the correct table.  However, when we try to
merge them, we get error messages.  Poking around, we
found that Word does not even recognize the fields.  

   We are fairly new to Mail Merge.  So any help and/or
suggestion you can provide would be much appreciated.
Peter Jamieson - 20 Jul 2004 19:15 GMT
My Word/Oracle experience is at least a couple of years out of date, but
here are a few things you could look at:
a. are you absolutely sure you are setting up the new data source
correctly? It isn't particularly easy to describe how it works, but for
example, at some point you will probably have to check one of the boxes that
says that you want to save login/security information. Typically, the end
result when you set up a new source using the standard facilities in WOrd XP
is that you get a .odc file in a My Data Sources folder. This is actually an
HTML file which you can try opening with Internet Explorer and see if the
data you are expecting is displayed.
b. the Oracle provider (for OLEDB connections, the default with Word XP)
and ODBC driver provided with Word XP are only designed to work with an old
version of Oracle - version 6 I think. They seemed to work with version 8i
(the last version I tried), but of course Oracle has moved on. I would
expect them to work with "old" features of Oracle even in the current
version, but
 - perhaps they don't
 - some Oracle field types probably won't work, e.g. user defined types.
Also, Oracle may have done more on Unicode text types recently and it
wouldn't surprise me if they don't work.
c. Oracle has an OLEDB provider for its own product, and it may still have
an ODBC driver. It may be worth trying these. In my experience, however, it
was harder to work out how to configure them and they did not appear as
reliable as the MS equivalents when used with Word.
d. It may be worth trying ODBC instead of OLEDB. You would need to set up
an ODBC DSN (either user, system, or file DSN) on each machine connecting to
the database, then check Word Tools|Options|General|"Confirm conversions at
open" before trying to connect tot he data source.
e. If you still have Access, it may be worth trying to set up Access links
to the Oracle tables you need, then use the linked tables or queries based
on them to get the data from Oracle.

Signature

Peter Jamieson

> Hello,
>
[quoted text clipped - 9 lines]
>     We are fairly new to Mail Merge.  So any help and/or
> suggestion you can provide would be much appreciated.
Parkite - 21 Jul 2004 13:38 GMT
Thank you so very much for your comments and
suggestions.  Some of them I have tried and a couple I
have not.  I will take a look at those.

This is very helpful and insightful.  Thank you again for
your help

>-----Original Message-----
>My Word/Oracle experience is at least a couple of years out of date, but
[quoted text clipped - 44 lines]
>
>.
 
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.