Error: Object variable or With block variable not set when exporting a Query List

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.


Alternative Solution:

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

Environment

 Raiser's Edge
 7.93
 7.94
 7.94.6116.3
 7.93.5782.11

Was this article helpful?