Multiple Email Address

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.

Hi Brandon

You’re wanting to output all the email addresses for these constituents? If they have 3 email addresses you want all three output?

I have attached an output element and an output element parameter (in excel) that may do the trick. However, it will output the email addresses as separate rows of data ... 3 email addresses 3 rows.

This isn't a problem for list manager, but Extraction manager only uses output sets that output one row per constituent.

But at least it's a start.

Sandra

Thanks so much!  I'll give both of these a try and see if i can get them to work!

Sounds like some good suggestions - here is what we do:

1. Create a table using MS Access ODBC link to Tessitura tables T_EADDRESS and T_CUSTOMER - select customer_no & address from T_EADDRESS with all valid email and T_CUSTOMER include only active. This is the MS ACCESS SQL view (copy and paste if you want):

SELECT dbo_T_EADDRESS.customer_no, dbo_T_EADDRESS.address
FROM dbo_T_EADDRESS LEFT JOIN dbo_T_CUSTOMER ON dbo_T_EADDRESS.customer_no = dbo_T_CUSTOMER.customer_no
WHERE (((dbo_T_CUSTOMER.inactive)=1 Or (dbo_T_CUSTOMER.inactive) Is Null) AND ((dbo_T_EADDRESS.inactive)="N" Or (dbo_T_EADDRESS.inactive) Is Null)); 

2.  Export the table as a text file (.txt) to a folder or desktop and import & send to constituents via TMS.  We can also use the .txt file to update promotions in Tessitura after.