'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