Email Workbook Via Lotus Notes When A User Save It

Hi

I have a workbook, where in different Team Members update there Leave Records (againt there name with CL, PL ) and save it on Common Share Folder. I want whenver a user save that workbook, Excel should mail me that workbook on my Lotus Notes 7.0 mail address. I have no clue about the code to be used and how it can be done. Please Help

Thanks & Regards
Nicky

Thank You, I am going through this thread now .

Hope It works the way I want.

I do not need any hard coding & just want whenevr any user save a file, I get an email.

I will post an update on this soon.

While using the above code I am getting syntax error on Line 42, Col 11
End SubHTH

I hv not worked with VB so pls help.

I have fixed the above problem.. now getting another error
which says..
cannot create Object and stops on Notes.session