Pinnacle_West_Shore_Newsletter – ZIP Import

Pinnacle_West_Shore_Newsletter – ZIP Import is a 3 step automation in the UPMC Pinnacle BU

1. The automation first backs up the newsletter data the activity is called Pinnacle_West_Emails_Automation
2. The automation then grabs the emails with matching zipcodes ‘17055’,’17013′,’17011′,’17050′,’17015′,’17025′,’17019′,’17070′,’17020′,’17319′,’17345′,’17043′,’17339′,’17370′,’17090′,’17053′,’17101′,’17007′,’17065′,’17034′,’17324′,’17372′,’17365′ the activity is called Pinnacle_West_Shore_Emails_Zipcodes
3. Finally the automation imports the emails from the zipcode holding table into the newsletter for emails that are not already in the newsletter