Hi, I am trying to get mailmerge working on site and have come across a probelm.
The customer is using OpenEdge 10.1b and accesses the application via citrix. Word is installed on each users machine. Dependant upon the load the server will switch between one of 3 servers.
I am using the mailmerge program which i picked up from one of the threads
DEFINE VARIABLE chWordApp AS COM-HANDLE NO-UNDO.
DEFINE VARIABLE chDoc AS COM-HANDLE NO-UNDO.
DEFINE VARIABLE chMerge AS COM-HANDLE NO-UNDO.
DEFINE VARIABLE chNewDoc AS COM-HANDLE NO-UNDO.
&GLOBAL-DEFINE wdSendToNewDocument 0
CREATE "Word.Application" chWordApp.
chWordApp:ScreenUpdating = TRUE.
chWordApp:visible = FALSE.
chWordApp:displayAlerts = FALSE.
/* open the template document */
chDoc = chWordApp:documents:OPEN("e:\MMerge\MergeDoc.dotx",,YES,FALSE).
/* set Mail Merge object */
chMerge = chDoc:MailMerge.
/* open the data source */
chMerge:OpenDataSource("e:\MMerge\MData.txt").
chMerge:SuppressBlankLines = FALSE.
/* merge target is a NEW word Doc */
chMergeestination = {&wdSendToNewDocument}.
/* Run merge */
chMerge:EXECUTE.
/* get handle to new document (the merged one) */
chNewDoc = chWordApp:ActiveDocument.
chNewDoc:fields:update.
chWordApp:visible = TRUE.
RELEASE OBJECT chDoc.
RELEASE OBJECT chMerge.
RELEASE OBJECT chNewDoc.
RELEASE OBJECT chWordApp.
This works fine on my machine where both progress and word are installed, however it will not work on site as an error pops up telling the
The automation server for Word.Application is not registered properly
Please reinstall this server or try registering again.
I am not sure why i am getting this message
It could be because word is not installed on the application server
It could be because the users installation of word has the C2r problem mentioned in other threads
It could be a routing issue
Any advice on this would be most grateful
Thanks in advance
The customer is using OpenEdge 10.1b and accesses the application via citrix. Word is installed on each users machine. Dependant upon the load the server will switch between one of 3 servers.
I am using the mailmerge program which i picked up from one of the threads
DEFINE VARIABLE chWordApp AS COM-HANDLE NO-UNDO.
DEFINE VARIABLE chDoc AS COM-HANDLE NO-UNDO.
DEFINE VARIABLE chMerge AS COM-HANDLE NO-UNDO.
DEFINE VARIABLE chNewDoc AS COM-HANDLE NO-UNDO.
&GLOBAL-DEFINE wdSendToNewDocument 0
CREATE "Word.Application" chWordApp.
chWordApp:ScreenUpdating = TRUE.
chWordApp:visible = FALSE.
chWordApp:displayAlerts = FALSE.
/* open the template document */
chDoc = chWordApp:documents:OPEN("e:\MMerge\MergeDoc.dotx",,YES,FALSE).
/* set Mail Merge object */
chMerge = chDoc:MailMerge.
/* open the data source */
chMerge:OpenDataSource("e:\MMerge\MData.txt").
chMerge:SuppressBlankLines = FALSE.
/* merge target is a NEW word Doc */
chMergeestination = {&wdSendToNewDocument}.
/* Run merge */
chMerge:EXECUTE.
/* get handle to new document (the merged one) */
chNewDoc = chWordApp:ActiveDocument.
chNewDoc:fields:update.
chWordApp:visible = TRUE.
RELEASE OBJECT chDoc.
RELEASE OBJECT chMerge.
RELEASE OBJECT chNewDoc.
RELEASE OBJECT chWordApp.
This works fine on my machine where both progress and word are installed, however it will not work on site as an error pops up telling the
The automation server for Word.Application is not registered properly
Please reinstall this server or try registering again.
I am not sure why i am getting this message
It could be because word is not installed on the application server
It could be because the users installation of word has the C2r problem mentioned in other threads
It could be a routing issue
Any advice on this would be most grateful
Thanks in advance