Get answers quicker by searching

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

In this Discussion

  • Ben September 2013
Export of all receivers of a mail directly from campaign report
  • 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?

  • 1 Comment
  • Vote Up0Vote Down BenBen
    Posts: 3,484Sendy support

    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.
All Discussions