Add Your Tables

In the Add Tables dialog box, click the name of the table you want to add (for example, CLIENTS), and then click Add. Do this for each table you want to add. Close the dialog box when you're finished. For each table you selected, a list box is displayed on the Microsoft Query screen. This box lists all of the columns in the associated table.

In a list box, double-click each column that you want to read into your Word document. If you want to add all columns from a list box into your Word document, double-click the "*" at the top of the list box. If you prefer, you can select columns or further refine your query by clicking the SQL button in the toolbar and typing your own SQL statements.

Note: See Summary of Supported SQL Commands for a description of the SQL commands supported by Micro Focus XDBC.

Click OK when you're finished.

In the Microsoft Query dialog box, click File > Return Data to Microsoft Word.

If you or an administrator established database security methods during Micro Focus XDBC setup, the Micro Focus XDBC Login dialog box appears; type a valid User ID and Password, and click OK.

Note: If database security methods have been established and you previously supplied a correct user ID and password, this step is not necessary. If, however, you established security methods but didn't enter a user ID and/or password, the login dialog box will appear for you to do so now. If no security methods have been established, the Login dialog box will not appear.

The Mail Merge Recipient dialog box appears.

Make sure all the records are selected and click OK. Note that no records actually appear after you click OK. This is expected behavior, as this step is simply making the data records available to Microsoft Word. Additional steps are necessary to actually insert the data records into your document.

The Mail Merge Recipients dialog box provides options for refining your mail merge list. For example, you can add or delete records, and specify certain record criteria. For help on using the commands appearing in this dialog box, see Microsoft Word documentation.