'Subscribed' email addresses

MailChimp

 

MailChimp is a cloud-based email marketing solution, that allows designing and sending marketing emails.

These addresses are ready to receive email

Query Text

SELECT ListMembers.ListId, Lists.Name, ListMembers.Email, ListMembers."First Name", ListMembers."Last Name", ListMembers.CreatedDate, ListMembers.LastUpdate
  FROM ListMembers
INNER JOIN Lists ON ListMembers.ListId = Lists.Id
WHERE (ListMembers.Status IN ('Subscribed'))
ORDER BY Lists.Name, ListMembers.Email
  

Open Query