manually send a password to an existing user?
Is there a way I can manually send my users an email containing their password?
I have my site set on "Visitors can create accounts but administrator approval is required." so I would like to take the password out of the first welcome email they are automatically sent when they apply for an account. Then, when I have got round to activating their account, I'd like to send their password (which they'd see for the first time) along with my "your account is now activated" message.
I want to do this because, inspite of many warning messages, punters still try logging-on as soon as they see their password. Then they get cross. Then they email me a message about how I am messing them about.....
Is it possible to manually send passwords, when I am good and ready to send them?
Many thanks
Ng

Need a time lag
Yes, the notification workflow really should not send the user his/her username and password immediately upon submission but only until the administrator has activated the account. The users do get a confirmation message on the screen immediately upon submission which says the ff:
“Thank you for applying for an account. Your account is currently pending approval by the site administrator.
In the meantime, your password and further instructions have been sent to your e-mail address.”
and also this message in the automated email sent to them:
Your application for an account is currently pending approval. Once it has been granted, you may log in to http://softtester.org/test/drupal5/user using the following username and password:
.
But I guess some users don't have the patience to wait especially that Drupal (I tested it on my 5.2 install) doesn't send a follow-on email to tell the user that his/her account has been activated after an Administrator activated it. Perhaps this can be fixed?
If you find yourself not having time to activate registrations soon enough, you might want to choose "Only site administrators can create new user accounts", which basically requires you to manually create usernames and passwords for your users. You can also customize the automated registration emails. Or, choose "Visitors can create accounts and no administrator approval is required" and then regulate the account later if the user doesn't follow your site's policies.