- Clean up of a large attendee database: We currently have 20k+ which includes duplicates, inactive, etc.
We needed to clean up our address book last year.
First merge anyone who has the same source id or email address.
Then I created a custom contact field.
Ran the cross report Contact Event History to see who was marked accepted.
Exported to excel. In my custome field I labeled each row either KEEP or PURGE.
Then you can search the address book to remove those marked PURGE.
Caution: There is no undo.
------------------------------
Steven Schlossman
Jack of all trades. Master of none.
BMW Car Club of America
------------------------------