Note : Before you proceed with the following instructions, back up the database. If your organization integrates multiple Blackbaud products, refer to the Additional Requirements section of the backup article.


To delete a specific phone number or email address from all records:

Download and run the Delete Phones plug-in: The Delete Phones plug-in globally deletes phone numbers/emails by phone type OR deletes phone types for which there is no corresponding phone number/email address. 

To delete a specific phone number or email address from selected records in The Raiser's Edge 7.94 and higher:

  1. Create a Constituent query of records with phone numbers or email addresses to delete.
  2. Create a Constituent export that includes the query in Step 1.
  3. From Available Fields to Export, select the following fields:
    • Constituent information > constituent ID (or Import ID)
    • Phones > Import ID (To export a relationship's or contact's phone numbers, select Relationships, Individuals (or Contacts), Addresses, Phones, Import ID instead.)
  4. On the Phones screen, enter 1 in the number of Phones to export.
  5. Choose Selected Phones and move your specific phone type over to the right. Click OK.
  6. From Available Fields to Export select Phones, Phone Type.
  7. From Available Fields to Export select Phones, Phone Number.
  8. Click Export Now.
  9. Open the .csv file in Excel and sort by phone type.
  10. In the Phone number columns enter a caret (^) in place of the phone number or email address to be deleted.
  11. Save and close the .csv file.
  12. Import the file.
  13. Download and run the Delete Phones plug-in for blank phone numbers.

To delete a specific phone number or email address from selected records in The Raiser's Edge 7.93 and earlier:

  1. Create a Constituent query of records with phone numbers or email addresses to delete.
  2. Create a Constituent export that includes the query in Step 1.
  3. From Available Fields to Export, select Address, Preferred Address, Import ID.
  4. From Available Fields to Export, select Address, Preferred Address, Phones, Import ID Note: If needing to look at the phone numbers from any address, select this field from the All Addresses category instead. To export a relationship's or contact's phone numbers, select Relationships, Individuals (or Contacts), Addresses, Phones, Import ID instead.
  5. On the Phones screen, enter 1 in the number of Phones to export.
  6. Choose Selected Phones and move your specific phone type over to the right. Click OK.
  7. From Available Fields to Export select Address, Preferred Address, Phones, Phone Type.
  8. From Available Fields to Export, select Address, Preferred Address, Phones, Phone Number.
  9. Click Export Now.
  10. Open the .csv file in Excel and sort by phone type.
  11. In the Phone number columns enter a caret (^) in place of the phone number or email address to be deleted.
  12. Save and close the .csv file.
  13. Import the file.
  14. Download and run the Delete Phones plug-in for blank phone numbers.