Re: Merging Oracle data & Microsoft Word Forms

Dear Anne,

We have developed SQLWord that might be interesting for you:

SQLWord

Advanced Reportwriter integrating Oracle and Microsoft Word. You can create your own standardletters, contracts and any other reports using the data of an Oracle database within a Microsoft Word document. By placing the fieldnames (keywords) of the queries in the text of the document, SQLWord retrieves the necessary data from the Oracle database and integrates it in the generated output document. Nested structures can be used unlimited (master-detail-detail etc).

Please have a look at our website at http://www.sequel.nl

Sincerely,

Sequel Solutions

M. Armaghan Saqib <armaghan_at_yahoo.com> wrote in message news:87qmsn$k3b$1_at_nnrp1.deja.com...
>I had done exactly this sometime ago but in MS Access as follows:
>
>1. Create a passthrough query in MS Access to get Oracle data using
>ODBC.
>
>2. Create a form to compose email message and buttons etc.
>
>3. Merge the message with data from Oracle (using some simple lines of
>code) and send as email (using sendobject macro which uses your
>existing windows messaging profole to send email).
>
>Free free to email me directly if you want to have other infomration
>regarding this.
>
>regards,
>M. Armaghan Saqib
>+---------------------------------------------------------------
>| 1. SQL PlusPlus => Add power to SQL Plus command line
>| 2. SQL Link for XL => Integrate Oracle with XL
>| 3. Oracle CBT with sample GL Accounting System
>| Download free: http://www.geocities.com/armaghan/
>+---------------------------------------------------------------
>
>In article <0722a78c.731dbc0b_at_usw-ex0107-050.remarq.com>,
> Anne <goodwinakNOgoSPAM_at_kpt.nuwc.navy.mil.invalid> wrote:
>> I need to create a process that will dump a flat file of records from
>> an Oracle database, merge this data with a Microsoft Word Form, and
>> email the merged document to multiple users. The merged document must
>> be a 'form', ie., the recipient may only enter data in certain fields
>> and the remainder of the field is not modifyable. Has anyone done
>this
>> before and can offer me some tips?
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
Received on Fri Feb 11 2000 - 16:16:36 CET