We primarily use the household account email address for emails. However, we know that there are number of records with A1 or A2 has an email address, but the household primary email address is blank. We would like to update the household email address. I am pretty sure that process will be manual.
I have been trying to build a custom view in SQL or a even a list or extraction in Tessitura to locate the records where there is no household email, but either A! and/or A2 has email address. I have not found the solution. I can find the households with no email, but I have unable to find a way to find the A!/A2 with email a dresses.
Any suggestions would be appreciated.
We have a view that labels the customer_no as A1,A2,HH,I etc... You could use that to filter on T_EADDRESS. You could also simple use cust_type in T_CUSTOMER to get just HH and then join to T_EADDRESS for a null condition. Does that help?