Address Processing Fields

Address processing fields help you find the best address to reach individuals and organizations by prioritizing address processing fields.

Navigation

  1. Open the Query editor.

  2. From Criteria, select Addresses, Address Processing, and select a field.

Individuals

You can select these options to customize your query:

  • Seasonal addresses—Return the first valid seasonal address and include temporary

  • Address type priority—If no valid address is found, or you didn't select seasonal addresses, select and prioritize the address types to use.

  • No address found—If no valid address is found, select what you want the query to display.

Organizations

You can select these options to customize your query:

  • Add address types—Select the address types to use, and then prioritize their order.

  • If no address found—If no valid address is found, select Use blank address or Use specific address.

Contact Options

In single-row queries, you can select Contact's address to use the address of a contact at the organization. You can then select these options to customize how contacts are returned:

  • Contact types to include—Select the contact types to include, and then prioritize their order. If you leave this blank, the query includes all contact types.

  • Include one row in results for each contact found—If multiple contacts qualify, return one row for each. When this is not selected, the query returns one row for each organization, using the first contact type in your list.

  • If no contact found—If no contact qualifies, select Use blank address or Use specific address.