# How to query an email list of users that are not actived

**URL:** <https://meta.discourse.org/t/how-to-query-an-email-list-of-users-that-are-not-actived/122024>\
**Category:** Data & reporting\
**Tags:** sql-query\
**Created:** [July 3, 2019, 5:08pm UTC](https://meta.discourse.org/t/how-to-query-an-email-list-of-users-that-are-not-actived/122024 "2019-07-03T17:08:19Z")\
**Posts on this page:** 1\
**Showing post:** 1

<div class="post-metadata">

**Author:** ![Phuong\_SuSu](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/phuong_susu/32/148042_2.png) [@Phuong\_SuSu](https://meta.discourse.org/u/Phuong_SuSu)\
**Post date:** [July 3, 2019, 5:08pm UTC](https://meta.discourse.org/t/how-to-query-an-email-list-of-users-that-are-not-actived/122024/1 "2019-07-03T17:08:20Z")

</div>

Hello,

I would like to have an email list of users who are not actived.  
So I can send them a reminder.

I also suggest that Discourse have this feature:  
Auto resend an activation email after x day, or have a bulk-resend in admin tools.

---

_[View the full topic](https://meta.discourse.org/t/how-to-query-an-email-list-of-users-that-are-not-actived/122024)._