Skip to content

Export of all receivers of a mail directly from campaign report

BrittMalkaBrittMalka
edited September 2013 in Questions

I often send to more than one list at a time, and if I want to send again to those who hasn't opened - following this routine here https://sendy.co/forum/discussion/123/send-email-to-the-users-who-didnt-opened-the-emails-/p1 - it's very time consuming.

I have to go to each list and export active subscribers.

Would it be possible to add an Export function to the total number of subscribers, spanning over all the lists I've mailed to? E.g. where it says "Sent on Fri, Sep 20, 2013, 03:12PM to 1,449 subscribers" then the Export function?

Comments

  • BenBen

    Hi @BrittMalka,

    You can't do that at this time. But you can do this directly in your MySQL database via something like phpmyadmin.

    1. Go to 'campaigns' table, get the value in 'to_send_lists' and copy it
    2. Run this query → SELECT name, email FROM subscribers WHERE list IN ('to_send_lists') AND bounced = 0 AND complaint = 0 AND confirmed = 1 (where to_send_lists is what you copied in step 1)
    3. Then export the result in CSV

    Best regards,
    Ben

This discussion has been closed.

© Sendy.co 2024