Desktop Integration - Opening your query (no parameters) in Worid

By Ben Lamb, 4th February 2005

Save your query

If you are at the end of the query wizard click the "Save Query" button and save the query to your hard drive.

If you are in Microsoft Query go to File->Save As.

Using the saved query in Word

Open Word, and display the Mail Merge toolbar to make life easy.

To add this toolbar, go to

Tools -> Letters and Mailing -> Show Mail Merge Tool Bar

This will display a Mail Merge toolbar to the screen.

Connect to the data source (your query)

To connect to the query you have created, you must open a data source. This is done by clicking the 'Open Data Source' button shown below.

Navigate to where you saved the query and click open

Then connect to the database

Proceed to Using Mail Merge for how to use the data.

---

Solid Rock provides Oracle consulting, support and development services. See our Oracle Consulting page for more information.