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.

If you are unable to run the Delete Phones Plugin, please follow the instructions under If you are unable to run the Delete Phones Plugin


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.

If you are unable to run the Delete Phones Plugin:

  1. Create a new Phone Type table entry called "DELETE ME"
    1. In The Raiser's Edge, navigate to Config>Tables
    2. Select Phone Types
    3. Click New Table Entry
    4. In the Description field, type DELETE ME
    5. Select Telephone Number from the Phone Number Type drop-down
    6. Select <None> from the Phone Number Format drop-down
    7. Click OK
  2. Create a Constituent query of records with phone numbers or email addresses to delete
  3. Create an Import file that includes the query in Step 2
    1. In you’re the Raiser’s Edge database, navigate to Admin>Import
    2. Under the Constituent category, double-click on Constituent Phones
    3. On the General tab of the import window, select the following options:
  • What do you want to do? Create Import File
  • Options:
  1. Click Include>Selected records
  2. Search for the query saved in Step 2
  3. Click Open
  4. Under the Include… button, select Include all fields in the import file
  • What file do you wish to create?
    1. Click the ellipses icon
    2. Designate to where you want the import file to export
    3. In the File name field, type your desired file name in the format [file name].csv
    4. Select Text Files (*.txt, *.csv, *.prn) from the Files of type drop-down
    5. Click Open
  • What ID field do you want to use? Use the Constituent ID
User-added image
  1. Click Create Now
  2. Click the Close button on the Import Complete! Window
  1. Update the import file
    1. Open the exported import file
    2. Update the PhoneType column with the text, DELETE ME for any rows that have a phone number that you wish to delete
User-added image
  1. Save the spreadsheet and close the spreadsheet
  1. Import the file:
    1. In your The Raiser's Edge database, navigate to Admin>Import
    2. Under the Constituent category, double-click on Constituent Phones
    3. On the General tab of the import window, select the following options:
  • What do you want to do? Update existing records
  • Options: Validate data only
  • What file do you wish to import? [Map to the file path where you saved the updated CSV from Step 4]
  • How do you want the system to identify existing constituents? Use the Constituent ID
User-added image
  1. Click the Fields tab
  2. Confirm your fields are mapped like the screenshot below:
 User-added image
  1. Click Validate Now
  2. Confirm that there are 0 Exceptions in the Import Complete! window
  3. Click Close on the Import Complete! window
  4. Navigate back to the General tab in the import window
  5. Unmark the Validate data only checkbox
  6. Click Update Now
  1. Delete the Phone Type, DELETE ME, using the Delete Table Entries plugin


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.