Clear "Bad Address" user-defined fields

If you use a user-defined field called "Mailing status" to track which constituents have bad addresses, we recommend you run a mass update after each AddressFinder (NCOA) run.

1. From Management, click Mass Update. The Mass Updates page appears.

2. Under Update Existing Items, click Update Existing Accounts.

3. Select the category that corresponds to AddressFinder (NCOA).

   Tip: For eTapestry clients in the United states your category is probably called "AddressFinder (NCOA) Codes." For Canadians, use the queries you created for each code. Refer to Create Queries for Updated Canadian Addresses.

4. Select the query that contains the addresses changed by AddressFinder (NCOA). Include addresses with the following NCOA codes:

   • Address Standardized (Valid)

   • Address Updated (Corrected)

5. Under Update Type, select Remove. This will clear the Bad Address value from the Mailing Status field for constituents whose addresses were corrected by the AddressFinder (NCOA) run.

6. For Account Values, click Mailing Status under Base. Then, select the Bad Address value from the menu that appears.

7. Click Next. A preview summary appears so you can verify the number of accounts that will be updated.

8. Click Next to run the mass update. Accounts whose addresses were corrected by AddressFinder (NCOA) are no longer marked as having bad addresses.

   Warning: While the mass update is in progress, users cannot access the affected records. We recommend you run the mass update when users are typically inactive. You can log out while the mass update is in progress.