We use Wordfly for all mass emails. We'd like to expand and restrict emails to those marked with "Allow Marketing" which may mean multiple emails in a record. Can an Output Element be built which can pull all emails marked with "Allow Marketing" and include all of those in an individual and household record? I tried modifying the code below, but no luck. The code below pulls ALL active emails successfully, but I'd like to have it filter Marketing emails only.
Many thanks.
Chandra
The element pulls all active email addresses from a view called VS_EADDRESS.
Here’s the code for the TR_QUERY_ELEMENT_GROUP system table:
Data From: (select distinct address, customer_no from VS_EADDRESS where inactive = 'N')
TR_QUERY_ELEMENT:
Data Select: !.address
Single Row = checked (will not affect output)
Answering my own post. I was able to filter Marketing emails by using the Data From code below. Now I'd like to pull the salutation assigned to the email. Any help would be appreciated..
(select distinct address, customer_no from VS_EADDRESS where inactive = 'N' and market_ind='Y')