[Openroad-users] Word documents embedded in OR troubles ...

[Tulloch, Alex]

I have a way of using Word Mail-merge to produce invoices from our
Openroad application.

 

The word document is created to run the merge command on open, (every
time the document is opened it queries the DB for the data).

 

The merge is based on a query of a DB table, which I fill with the data
I wish to appear on the merged document, I then just make an active-x
call from Openroad to Word to open the document, and Word handles the
rest for me.

 

I found it was much easier to do most of the work in Word as I have had
problems with active-x calls from Openroad before - it is probably only
of use for producing reasonably fixed format documents like invoices,
but has been in use for 3 years without problem - probably because its
quite simple.

 

I can try to make up an example if you like.

 

Alex.

 

-----Original Message-----
From: openroad-users-bounces at peerlessit.com
[mailto:openroad-users-bounces at peerlessit.com] On Behalf Of Pete
Wilkinson
Sent: 16 March 2007 15:31
To: openroad-users at peerlessit.com
Subject: [Openroad-users] Word documents embedded in OR troubles ...

 

I was wondering if you could embed a Word document in OR, and I came
across this ActiveX component/container "DSOFramer" from Microsoft.

It works ok, albeit a bit slowly, but unfortunately the main thing I
would like to do, which is Mail Merge, is of course disabled.  I get a
"method is not available because this document is in another
application" error message in the trace window when I try execute the
mail merge.  Looking on google, other people seem to have encountered
the same problem, but have no solutions, I think its something to do
with COM, but its all way above my simple OR brain ...  so I was
wondering if anyone else had tried to do anything similar, mail merging
in an embeded Word document, using this or any other ActiveX container?

Link to DOSFramer info & download .... 
http://support.microsoft.com/default.aspx?scid=kb;EN-US;311765

**********************************************************************

This email and any files transmitted with it are confidential and

intended solely for the use of the individual or entity to whom they

are addressed. If you have received this email in error please notify

the system manager.

 

This footnote also confirms that this email message has been swept by

MIMEsweeper for the presence of computer viruses.

 

www.mimesweeper.com

**********************************************************************

 


This message has been checked for all known viruses on behalf of SunGard
Vivista by MessageLabs. 

http://www.messagelabs.com or Email:
mailsweeper.info at vivista.sungard.com

For further information http://www.sungard.com/vivista



*****************************************************************************
This e-mail contains confidential information and is intended solely for use by the individual named or entity to whom it is addressed.  Please notify the sender and postmaster at aviagen.com immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system.  If you are not the named addressee, you are notified that disclosing, copying, distributing or taking any action in reliance on the contents of this information is strictly prohibited.  Aviagen accepts no liability for the content of this e-mail and any consequences of actions taken in reliance on the contents, unless that information is subsequently confirmed in writing.  Any views, opinions or actions presented in this e-mail are solely the author's and have not been approved by Aviagen.  Any defamatory statements or infringing communication is contrary to Aviagen policy and outside the scope of the employment of the individual concerned.  No employee or agent is authorized to conclude any binding agreement on behalf of Aviagen with another party by e-mail. Aviagen has taken reasonable precautions to ensure no viruses are present in this e-mail, but cannot accept responsibility for any loss or damage arising from the use of this e-mail or attachments.
*****************************************************************************

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://peerlessit.com/pipermail/openroad-users/attachments/20070316/a57b192c/attachment.html