Implemented in version 7.70.638, revision 6
Download and install the latest patch, which contains all fixes from previous patches. If you are running an older version, download and install the latest version and then the patch.

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 solution.


You can identify records that have duplicate addresses and merge the addresses using the Merge Duplicate Addresses Utility.
  1. Identify records with duplicate addresses
  2. In Reports, Directories and Lists, select the Duplicate Addresses Report and click New on the action bar.
  3. On the General tab, mark the checkboxes for the criteria to use to identify duplicate addresses.
  4. If you mark Address lines, you can enter the number of characters to use to determine duplicates in the Use [ ] characters of the address lines.
  5. Note: When comparing address lines, the program ignores punctuation and recognizes address abbreviation equivalents (such as Ave for Avenue, Ln for Lane, and Pky for Parkway).
  6. If you mark ZIP/Postcode, you can enter the number of characters to use to determine duplicates in the Use [ ] characters of the ZIP/postcode.
  7. To create a query of records with duplicate addresses, mark the Create an output query of records checkbox.
  8. Select the appropriate filters on the Filters tab.
  9. On the Columns tab, define the columns to include in the report, such as Record Name, Address Type, and Address Lines.
  10. Select File, Save from the menu bar.
  11. Name and save the report parameters.
  12. Preview and print the report.
 
  • Merge duplicate addresses
     
    1. In Records, using the Duplicate Addresses Report as you guide, open a record with duplicate addresses. For a large group of records, use the output query from the report, open a record from the results tab, and click the blue arrow on the record to scroll to the next record in the query.
       
    2. Select the Addresses tab.
       
    3. Click Merge Addresses on the action bar.
      User-added image
    4. On the Addresses tab, mark the checkboxes for the criteria to use to identify duplicate addresses.
       
      • If you mark Address lines, you can enter the number of characters to use to determine duplicates in the Use [ ] characters of the address lines.

        Note: When comparing address lines, the program ignores punctuation and recognizes address abbreviation equivalents (such as Ave for Avenue, Ln for Lane, and Pky for Parkway).
         
      • If you mark ZIP/Postcode, you can enter the number of characters to use to determine duplicates in the Use [ ] characters of the ZIP/postcode.
          
         
      • Select the Preview tab.
        • To remove a group of addresses from the merge process, unmark the Merge checkbox.
           
        • To change the address marked as the primary address within a merge group, use the arrow buttons on the action bar.
           
           
      • Click Merge to merge the duplicate addresses.