• Replies 3 replies
  • Subscribers 412 subscribers
  • Views 104 views
  • Users 0 members are here
Related

Constituent Email List

Sarah Hird
$organization
Hello All! We are just getting into Tessitura in our organization and I need help pulling a list constituents and their email addresses for our communication network for eblasts. When I create a new list I cannot choose "has" what should I be doing? What I need: Constituent Name Email Phone Number Address
  • $organization
    Hi Sarah, Welcome to the tribe! I'm not sure which specific criterion you're using but we use "Eaddress Type" which allows for the use of "has". As Tony points out, Extractions can be used - and they're great for more complex queries - but I guess it depends how far down the track you are and whether or not you're at the point of using Contact Point Purposes. There you go, that's my 2c worth! Martin
  • $organization

    I would recommend using Extractions and under Communications Management section select “Email Address” in the Contact Point Category Dropdown.  Select the checkbox “Only select constituents if they have this contact point category.  You can suppress specific constituents and include multiple segments of constituents.  If you “Extract Constituents” without any Output Set selected, I believe your desired output will be included in the output file.

     

    Best,

    Tony

     

    Tony Exler
    Director of Data Standards
    Nashville Symphony
    Schermerhorn Symphony Center
    One Symphony Place
    Nashville, TN 37201-2031
    T 615.687.6535 F 615.687.6403
    texler@nashvillesymphony.org
    NashvilleSymphony.org

     

    From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Sarah Nickerson
    Sent: Monday, January 23, 2017 1:29 PM
    To: Tony Exler
    Subject: [Tessitura Development Forum] Constituent Email List

     

    Hello All! We are just getting into Tessitura in our organization and I need help pulling a list constituents and their email addresses for our communication network for eblasts. When I create a new list I cannot choose "has" what should I be doing? What I need: Constituent Name Email Phone Number Address




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Development Forum. You may reply to this message to post to the Development forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

  • Former Member
    Former Member $organization
    Hi Sarah There's actually two slightly different aspects to this, and I'm not sure which one you're asking about.. First one is pulling a List of people for whom you have an email address. That's what Martin and Tony are talking about, basically. But if you also need to end up with a dataset of those constituenti to work with, with their id, names, email and other address details, what you need is to look at defining an Output Set, and then run the "execute an Output Set" report, specifying your List, and the appropriate Output Set, which will let you save the result as an excel file, and go on from there. There are some pre-defined Output Sets in Tess that you can use, and I suspect one of those will be a reasonable match to what you need. (Nice-looking island, btw.....) Ken