Description:

The Targets property of the SQLXL object can be used to reference one of the classes that implements functionality for possible output targets. Using predefined constants a reference can be obtained to the objects: litExcel, litWord, litOutlook

In the scenario where queried data is output you should set the properties of the Target object to how you want the output to be handled.

Example:

Set the outlook target to send the email directly after putting the data in:

Dim t As Object
Set t = SQLXL.Targets( litOutlook )
t.SendImmediately = True