SQLWord.com

Mailmerge Oracle data into Microsoft Word

All Oracle database users know that it is quite difficult to mailmerge Oracle data into Microsoft Word documents. Sequel Solutions has developed a report-generator which gives you a powerful tool to solve this problem. You can define your source documents in Microsoft Word and use SQLWord to generate output documents merged with the data from your Oracle database.

The existing reporting-tools mostly use their own specific format and don’t integrate at all to Microsoft Word documents.

• Oracle Reports is a powerful but complex tool and has a long learning curve for developers. The reports created by Oracle Reports can't be used in Microsoft Word for further modifications.
  
• Mailmerge in Microsoft Word has very limited possibilities and is difficult to use. It is not possible to create master-detail documents.

When using SQLWord you can create your own standard letters, contracts and reports, integrating with the data of your Oracle database.

Using the SQLWord Developer9i application, you can place several SQL-statements enclosed by <% tag %> scriptlets inside the text of a Microsoft Word document. SQLWord9i follows the syntax of Oracle PL/SQL Server Pages <% tag %> declarations.

Microsoft Word documents with <% tag %> scriptlets can be stored by the SQLWord9i Developer application into your Oracle database, compiled as PL/SQL-procedures. By calling the PL/SQL-procedure that you created from your Microsoft Word document, SQLWord retrieves the data from your Oracle database and integrates it in the generated output document.

If you run SQLWord “web-enabled” through the Oracle HTTP server, the output document is send to the webbrowser on the client, where the received output document is opened with Microsoft Word (Windows) or OpenOffice (Linux).

If you run SQLWord “client-server” by using the SQLWord Run application, the output document is created on the LAN and is opened with Microsoft Word.

SQLWord can be implemented in several "web-enabled" applications, such as Oracle Forms9i or higher. An implementation example is included.

Read the SQLWord9i-manual

Advantages

• Full use of all Microsoft Word options such as different lettertypes, bold, underline, graphics, tables.
• SQL statements are defined in the source Word document. The advantage is that both source and layout are defined on one and only one location.
• Nested structures can be used unlimited (master-detail-detail etc).
• Full use of all SQL commands such as select, update, delete, insert, even create or drop. It is also possible to define and execute PL/SQL blocks. In these PL/SQL blocks all standard PL/SQL functionality can be used, so calling stored procedures, functions and packages is no problem.
• Conditionally use of text blocks. In the scope of the condition it is possible to use the full scale of possibilities of SQLWord and Microsoft Word.
• The layout of the output document is completely done in Microsoft Word. Probably you are already familiar with that!
• Microsoft Word tables are supported and can be filled with the data retrieved from the Oracle database. This gives your documents a professional look!
• Dynamic headers and footers are supported.
• Graphics are supported. You can use bitmaps for logos etc.
• During the creation of the output document it is possible to supply the parameters interactively.
• Integration with Oracle*Forms9i.
• Great performance.

Requirements

Prices

License prices are based on the number of end-users. The basic license is for 1-8 users.
For large sites we offer interesting site-licences.

For more information about prices, please contact our sales department.

You can download SQLWord9i from here. We appreciate your comments!