When a user tries to export a Query List, the following error may appear:
Error: Object variable or With block variable not set
The file is created, but it only contains file headers.
Download and install the latest patch which contains all fixes from previous patches. If you are running an older version, download and install the latest version and then the patch.
If duplicate records due to Output will not be an issue with the query, Include the Query List in a new query.
1. Go to Query>New Query, and create a new Constituent, Static query 2. Select Tools>Query Options... 3. Select the Record Processing Tab 4. Mark box for Select from query: 5. Click binoculars and select the Query List 6. Click OK. This query will now only include records in the Query list 7. Select the Output tab and add desired output fields 8. Export query results