<p>I'm not sure if the Sprout Email plugin can do anything to help you or not, but I can think of a few options that would involve simple, <a href="https://pluginfactory.io" rel="nofollow noreferrer">custom</a> <a href="https://craftcms.com/docs/plugins" rel="nofollow noreferrer">plugins</a>.</p>

<p>Every user has a "Require a password reset on next login" that an administrator can set from the CP under their settings.  You probably don't want to do that manually for 3,000 users, but a simple plugin (or a simple SQL query) could set the <code>passwordResetRequired</code> column in the <code>craft_users</code> table in the database to <code>1</code>.</p>

<p>If you wanted to send an email and include a password reset link in that email ahead of time, a plugin would change that column to <code>1</code> for all users and follow similar logic in the <a href="https://craftcms.com/classreference/controllers/UsersController" rel="nofollow noreferrer">UsersController</a> for getting the password reset link and include that in the email body that you'd send to every user programatically.</p>

CC BY-SA 3.0
2017-08-23T04:11:55.060Z
the sql query route would probably be easiest if OP has access to the database administration
Keith M
CC BY-SA 4.0
2019-10-22T12:10:53.547Z
did anyone write a plugin for this? I am in the same situation. Although I might just write them a manual on how to reset the password. But it's rather lame and customers tend to get confused very easily. Anyone?
outline4
CC BY-SA 3.0
2017-08-17T19:09:42.807Z
2017-08-17T19:09:42.807Z
Brad Bell
<p>I have a bunch (about 3000) of imported users from a website, which is currently on a redesign.
When the site is finished, I would like to send an email to all users,
saying that the site is relaunched, has a new structure ect. and therefore they have to set a new password.</p>

<p>I found nothing in the Craft settings, as well in the forum.</p>

<p>Do I have to write a plugin?
Or can I achieve this with the Sprout Email plugin?
I saw, there is a event "When a user logs in".</p>

<p>This could also work for me: a users logs in and gets automatically
to the a page to set a new password.</p>

<users><emails><activation><plugin-sproutemail>
Send Password Reset Email to all users at once
# Send Password Reset Email to all users at once

(Asked by: username_0 on 2017-08-17)

I have a bunch (about 3000) of imported users from a website, which is currently on a redesign.
When the site is finished, I would like to send an email to all users,
saying that the site is relaunched, has a new structure ect. and therefore they have to set a new password.

I found nothing in the Craft settings, as well in the forum.

Do I have to write a plugin?
Or can I achieve this with the Sprout Email plugin?
I saw, there is a event "When a user logs in".

This could also work for me: a users logs in and gets automatically
to the a page to set a new password.

**Tags:** users, emails, activation, plugin-sproutemail


---

## 1 answers

### Answer by username_1 on 2017-08-17. Score: 3

I'm not sure if the Sprout Email plugin can do anything to help you or not, but I can think of a few options that would involve simple, [custom](https://pluginfactory.io) [plugins](https://craftcms.com/docs/plugins).

Every user has a "Require a password reset on next login" that an administrator can set from the CP under their settings. You probably don't want to do that manually for 3,000 users, but a simple plugin (or a simple SQL query) could set the `passwordResetRequired` column in the `craft_users` table in the database to `1`.

If you wanted to send an email and include a password reset link in that email ahead of time, a plugin would change that column to `1` for all users and follow similar logic in the [UsersController](https://craftcms.com/classreference/controllers/UsersController) for getting the password reset link and include that in the email body that you'd send to every user programatically.

> **Comments:**
> **username_2**: the sql query route would probably be easiest if OP has access to the database administration  
> **username_3**: did anyone write a plugin for this? I am in the same situation. Although I might just write them a manual on how to reset the password. But it's rather lame and customers tend to get confused very easily. Anyone?  

---

