Preferred addresses that are actually bad addresses

Long post ahead — I’m sharing a full explanation and resource list so this thread can serve as a reference for others down the road. (I'm also very passionate about this topic and got hyper-focused!)

I completely understand the frustration with returned mail. But creating blank preferred addresses to “push aside” bad ones is not a safe or sustainable solution, and it will cause significant long‑term data quality issues.

RENXT/RE is built on the assumption that every constituent will always have a preferred address — even if that address is coded as Do Not Mail, Invalid, Lost, Previous, Deceased, or whatever terminology your organization uses. The system expects users to exclude non‑mailable addresses when generating mailing lists, not to hide them or overwrite them with blanks. Introducing blank preferred addresses breaks that logic, interferes with Address Processing, and ultimately makes the data harder to manage and more prone to errors.

1. Lists in Web View are not designed for mailing production!
Lists always pull the preferred address and cannot filter on “has no valid address,” which is exactly the scenario you’re trying to manage. This is why Lists produce misleading results.

Mailings should be generated using:

• Query (Web View) + Export (Database View)
  (Export is coming to Web View, but not yet)
• Address Processing, which applies all address rules and ensures only mailable addresses are selected

Or at minimum, export the preferred address after excluding anyone with no valid address.

Address Processing evaluates seasonal, preferred, alternate, and attribute‑based addresses and determines whether a valid, mailable address exists. If none is found, it can automatically exclude the record from the mailing — exactly as designed.

Query and Export both allow you to easily exclude Deceased, Inactive, or Has No Valid Address with a simple checkbox, and Export handles Household logic correctly.

2. Address Processing exists specifically to prevent returned mail
Address Processing is the engine that determines which address should be used for any mailing, report, or export. It evaluates:

• Seasonal addresses
• Address types
• Address attributes
• Do Not Mail flags
• Lost/invalid/previous addresses
• Contact logic for organizations
• Fallback rules when no valid address exists

Lists bypass Address Processing entirely, which is why they cannot reliably produce mailable output.

3. Blank preferred addresses create more problems than they solve
If you import blank preferred addresses:

• Bad addresses could be re‑added as preferred
• Address history becomes unclear and unreliable
• Users won’t see the inactive/bad address without digging
• A blank preferred address can cause Address Processing to stop before it can evaluate the inactive/bad address or check for any other viable options — like a seasonal or business address — so the system never completes its full review.

This workaround undermines the system’s design and increases the risk of bad mailings.

4. Training users is easier than cleaning up the fallout
It may feel faster to engineer a workaround, but you’ll spend far more time later fixing duplicates, restoring preferred addresses, correcting relationships, and re‑training users anyway.

A short training on “Mailings must be built from Query/Export + Address Processing, not Lists” is far more effective and aligns with how the software is intended to function.

Further Resources
These resources reinforce the correct workflow and explain how RE determines which addresses are mailable.

Product Documentation: Addresses in Raiser’s Edge NXT
This is Blackbaud’s current, authoritative documentation on address fields, preferred address logic, seasonal addresses, and how RENXT handles address selection.

Query Criteria: Has Valid Address / Deceased / Inactive
How RE determines “Has No Valid Address” and how to use it in queries:
Records are marked as Has No Valid Address
What is the Has No Valid Address checkbox?

Mailing Best Practices (Highly Recommended)
@Bill Connors’ guide to Getting the Best Success with Mailings from RE
(Older, but still one of the clearest explanations of how RE mailings are designed to work):

Idea Bank Request
Finally, for anyone following this thread, there’s also an Idea Bank request to add a ‘No Valid Address’ filter to Constituent Lists

Note: I asked Copilot to help me organize and format the points in this post for clarity.