The ELRC gets its contacts from the Provider Management and the Family Management segments of Pelican. In order to send emails to only registered individuals, the contact list in Constant Contact must be updated monthly. 

In this part of the newsletter project, I pulled a report of providers. After 24 hours the report could be downloaded. From there, I filtered the document to see if there were any missing email information. Any provider with a missing email is noted and the names are given to the Provider Services Manager to collect the missing information and they will update Pelican. This ensures the system is up to date. 

Once the contacts were organized I could update the contacts. To do this, I removed the old regional email lists and created new ones for the current month. Then I uploaded the spreadsheet to Constant Contact. A simialr procedure is followed for families.