This is working like a gem. Thanks a zillion for your help

On another note, one more thing,

Is there a way that I can copy the contents of a worksheet from the excel attachment and send that in a body of an email. Again, here also, the email coming would have a predefined subject with predefined attachment name.

The reason for this, many people would be reluctant to open the attachment so it is easier that the contents of excel are in the body of the mail.