you would need to edit the server behaviors on the forgot password page for Sending the email (and updating the user if you are using encryption) to use the email column for look up instead of the username column.
Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.
These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.