To list all participants and those that made sponsoring pledges on their behalf with addresses:

  1. Create a Gift query with criteria as follows:
    • Gift Information > Gift Is Linked To An Event As A Sponsoring Pledge equals Yes
    • AND Event ID equals *your event
  2. Save and close this query
  3. Include this query in a Gift export with output as follows:
    • Linked Events > Sponsoring Pledge > Participant
    • Constituent > Constituent Information > Name
    • Constituent > Address > Preferred Address > Address Block
  4. Export to Excel or other file type