Hello,
Does anyone have an output set element they use to get more than the primary email address on an account? If you do have one, does it need any SQL programming or can it all be setup in the QUERY system tables?
Thanks for any advice you have.
- Chris
Several years ago, but still seems to work for me. Gives a separate row for each eaddress. I remember using for audit, but not for eblasting or anything like that.
TR_QUERY ELEMENT
Description: Eaddress-Multi-Types
Group ID: EaddressInformation1
Data Select: !.email,!.type,!.inactive,!.market_ind
Single row N
TR_QUERY_ELEMENT_GROUP
Description: EAddress Information 1
Data from: (select e.customer_no, e.address as email, e.eaddress_type, e.inactive,e.market_ind, t.id, t.description as type from vs_eaddress e join tr_eaddress_type t on t.id = e.eaddress_type)
Data Where: (blank)
Category: Eaddress Information