We still need to know more info.
What do you have so far?
Have you yet been able to attach  to your Lotus Notes session?
Or are we starting from the beginning?

I have few points to clarify:-

1) I am using Lotus Notes where I have to use two email  ids one is in my name
and another one is generic email address!!
2) I can sent out email from my personal email address, but i was unable to sent
out an email from the Generic email address
3) I have a template in excel file  and which needs to be attached in paste
special format automatically with respective data
4) Moreover, I want to attach  an excel file in a specified path

I would be very happy, if you could you please advice me on the above points
with some sample codings