Resend confirmations

Hi there
I understand that to resend a confirmation email a user must be disabled (blocked) and unconfirmed but i have over 3500 users and want to resend confirmation to them all - how can I make them all be in this state automatically in order to resend? Please say theres a way to do this without having to go into each record manually?
Your help is appreciated
Jodee

There's no bulk feature for this. So I guess the quickest way to do this is to do it directly in database. You'd need to first set the block column in _users then set the confirm column in _comprofiler. I suggest making a backup of your database before doing this. This also won't fire any triggers so if you've anything installed that maybe dependent on it then this could be an issue. Why are you needing to resend confirmation for your 3,500 users though? If you just imported them I suggest re-imported them as not confirmed (using CB Juice).