Enrolment

Hi

I need to send email with the moodle generated password from the enrolment and not at the moment of authentication.

When a student is enrolled in a course he will receive his password at this moment.

How can it be done ? may adding a collumn at user table that takes care of user-sent-password ?

Any ideas

Thank´s in advance