• Replies 4 replies
  • Subscribers 332 subscribers
  • Views 140 views
  • Users 0 members are here
Related

Multiple Email Address

Brandon Walls
$organization

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!

Parents
  • Former Member
    Former Member $organization

    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.

Reply
  • Former Member
    Former Member $organization

    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.

Children
No Data