Way to NOT deduplicate multiple lists with same Students from EE queries on same email message?

Options
Jimmy Cudzilo 4
Jimmy Cudzilo 4 ✭
Ancient Membership Facilitator 1 Name Dropper Photogenic
in Blackbaud Raiser's Edge NXT®: General Discussion
We store all of our parent/guardian email addresses on BOTH the student and parent records in EE. This affords us the required flexibility in writing queries based off the Student records (ie Progression Entries) and get the emails of the parents still needed to complete our Online Reenrollment Forms (for example).



I have multiple queries set up in EE and I have multiple lists set up in BBNC pointing to these identical (except name) queries. Each list pulls a different Email address from the Student Record in EE; Mother's Home, Mother's Work, Father's Home, and so on...



This stops the system from bombing when I was using one query with multiple email lists for a single email message, but now it appears to be deduping the lists that I am bringing over.



So instead of getting all of the parent's email addresses for these students, I only get the first occurrence of the student (with or without an email address).



Thoughts? Ideas? Solutions?



FYI - I have a total of 10 different lists to get all of the emails for these students...
Tagged:

Comments

  • Karen Badham
    Karen Badham ✭
    Ninth Anniversary Facilitator 3 Photogenic
    Hey Jimmy,



    The way to do this is with multiple lists. You put the query into multiple lists since at the list level we can select a phone type for that list to use.



    Thanks!


    Karen
  • Jimmy Cudzilo 4
    Jimmy Cudzilo 4 ✭
    Ancient Membership Facilitator 1 Name Dropper Photogenic
    Hey Karen,



    When I connect multiple lists to the SAME EE Query, BBNC bombs on the email message distribution. So I have been sending multiple email messages (one for work and one for home) since these lists had been based off of the same query in EE.



    For our online reenrollment though, I have a total of 20 lists (10 each for two different contracts) so the former practice of sending a different email message for each list based on the same query (different phone type selected in BBNC at the List level) would not work. So I created 20 queries in EE then my 20 lists (pointing to the different EE Queries and EE Phone Types on the Student records).



    I did this so that I could send TWO emails as opposed to 20. When I composed the message and added the 10 lists to each message the system deduped the lists so that only the very first list was sent to. So instead of an audience of 65,100 I had an audience of 651.



    Thanks,


    Jimmy

Categories