Ravi,
You are not accepting PMs, so I have to post here.
Please do not take my post in your thread of attachments as a personal insult.
It is just that you really will not help yourself if everyone is prepared to write the code for you.
I am not that experienced, so cannot knock up code off the top of my head. I google for what I am looking for and then amend, and that way I have learnt more and more of Access.
Now when I want to do something, like email data, I look to see where I have done this previously, Copy the code and amend it. The beauty of this however, is that I *understand* the code, as I amended it in the first place.
HTH