CUSTOM SCRIPT: Subscribe new email addresses to default lists

This script provided by Simon Basyuk at Carnegie Hall is meant to run nightly. It scoops up all new to file email addresses and subscribes them to any mail2 lists you have that are marked with the "default" indicator. This subscribe happens in Tessitura, and the patrons are scooped up the next time an import is done to one of the default lists, and the new preference are added. 

Thanks for contributing Simon!

lp_chc_run_lwp_m2_insert_subscription.sql
 

Still need help? Contact Us Contact Us