I want to do following - 1) getting email from user. 2) verifying with table 3) then mailing him the password. how can I do that? I am not clear about 3rd option.
Do you mean a "forgot password" functionality? That is: User provides email address in form Form processor searches database for this email address, looks up password and then sends the user their password by email Or are you just asking how to send out an email, essentially, as you understand how to do the rest? A little more to go on here would be helpful.
PM me with your email address and I will send you a file that will give you everything you'd ever want to do vis CDOSYS.
if it is not about forget password then it may be about create password. easiest way in this case is , user define self the password because email address is unique enough , to use it in database like primer key index, and with this trick you will be fri to send password to user
I'm really starting to wonder why folks on this forum DON'T READ the intial question. I do, and THAT is what I respond to. Anyways, kharearch admits here that his REAL ISSUE is will sending mail via CDOSYS. However, yes, I'll agree, for whatever it is worth, that using email addresses as "unique identifier" is generally pretty safe, as email addresses are by default unique identifiers; problem is when rightfull end-user doesn't have access to that email account.