Create a Constituent or Gift export in a relationship/table-based format like Access or Crystal Report.
- If you need this information in Excel, after exporting to Access, select File, Export within Access and choose Excel as the format.
- In the export parameters, select Tools, Export Options.
- Mark the Export one-to-many records in separate tables checkbox.
- Click OK.
- Select the appropriate field. When prompted for the number of records to export, leave it blank.
Export the participant information by creating a Participant Export instead of an Event export.