What is the best way to extract email addresses on constituents with possible multiple email addresses?
I don't see in output builder an option for this, nor does an output set give multiple email addresses...ARGH! Any help would be greatly appreciated!
What you could do is create a list then use the manual edit feature. You could then use the follow aql code to get only the customer numbers that have more than one email address.
select
customer_no from
t_eaddress group by customer_no having count('x')>1
Once you have the list of customers with more than one email address, you could use this list in output set builder to get email addresses.
Thanks so much! I'll give both of these a try and see if i can get them to work!