Hi
It looks like even if you don’t require a postal address for record creation, if there are any postal addresses on a record one of them must be primary. When we get returned mail with no forwarding address, we are marking the address with a type of “Bad Address”. However, that is still an active, primary address that can be pulled into mailings if the correct suppressions are not in place. I don’t want to delete the bad address as it is good to have a historical record that we did have an address at one time since we do not require one. Does anyone have any ideas about how to handle this in a way that does not require suppressions?
Thanks
Jess Levy
SFMOMA
jlevy@sfmoma.org
Hey Jess,
I don't think we've come up with the perfect solution here, but this is what we do.First, e have 3 different Address Types to be used for bad addresses:- Incomplete Info (used mostly for website created accounts that didn't completely fill out their info)- Moved (when someone tells us they are moving but choose to not provide us with a new address)- Returned Mail (when we receive RTS mail that doesn't obviously fall into one of the above two categories)
These address types cause a warning icon to appear in our header so that the staff member is alerted and can verify the address when they are speaking to the customer.
Until such time as we can verify the address, we also take the extra step of prefixing the existing address content with a 0000 in front of the existing street 1 address (we also want the historical record of the address and don't want to simply delete it). By prefixing it with the 0000, we can easily sort any mail out lists by street 1 and remove the bad addresses in one fell swoop.
For example, if their street 1 address is "1234 Fake Ave" then we would have it say "0000 1234 Fake Ave" instead.