1. In the Commit Gift Batch screen, mark the option to Create a new batch of exceptions.
  2. Choose the other desired settings, then click Commit Now.
  3. In Batch, open the newly created batch of exceptions.
  4. Click the Batch Setup button.
  5. On the Fields tab, select Constituent ID and move it to the list of fields to include.
  6. Click the Data Entry button.
  7. In the Batch Data Entry screen, right click, then select Export the grid to Excel.
  8. Use the exported file to create a query.