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

Tip: Looking for answers? Try searching our database.

DOES MAIL MERGE WORK WHEN CALLED FROM ORACLE FORMS 6?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Miami - 16 Nov 2004 14:27 GMT
I currently call Word 2000 from an Oracle 6 form and use the mail merge
feature but when we upgraded to Office 2003 rthat feature no longer worked.
Can any one help?
Peter Jamieson - 16 Nov 2004 15:34 GMT
It has been a long time since I worked with Oracle Forms, but the chances
are that you have encountered one of the following problems:
a. Word is failing to connect because there is a new security feature which
pops up a dialog box whenever Word does something that would result in SQL
execution. If Word has been invoked via OLE Automation, the pop-up is not
displayed and Word behaves as if the user chose not to connect. There is
more info. at

http://support.microsoft.com/default.aspx?scid=kb;en-us;825765

b. Word is failing because Word 2000 used ODBC to connect to Oracle
databases and for some reason Word 2003 has been unable to connect using
that method and the same connection info. You should be able to check
whether Word 2003 can connect successfully by opening the document manually
in Word 2003 and seeing what happens. If Word does not connect, you will
probably have to go through the connection process again, but be warned that
by default, Word 2002/3 uses OLEDB, not ODBC, to make these connections. If
you now have a mixed Word 2000/2003 environment, I would not attempt to
maintain one version of these Word files - create and maintain one for use
with Word 2000 and another for use with Word 2003 and maintain them
separately.

There could also be some problem with the specific mechanism Oracle Forms
uses to initiate Word (are you using ole.invoke ?) or problems if your old
documents were using macros written in WordBasic. I don't have anything
specific in mind on those fronts though.

Peter Jamieson

>I currently call Word 2000 from an Oracle 6 form and use the mail merge
> feature but when we upgraded to Office 2003 rthat feature no longer
> worked.
> Can any one help?
 
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.