Hi!

I am kind of new to EXCEL VBA, and I am stuck in this problem. It goes like this.

I have an excel sheet which contains some information along with email id s on which the information has to be sent, there could be same mail Id for multiple information, what I need to do is send this information on the particular mail ID as attachment via lotus notes.
Here goes an example:
mail ID info1 info2 info3 info4 info5 mail@xyz.com 1 q f j j 123@xyz.com 2 w c h j abc@xyz.com 3 e c h n mail@xyz.com 4 r g j n
What I want to do is to create a VBA which will create an collective excel sheet for all the information corresponding to one particular mail Id in this case, similar to the following
info1 info2 info3 info4 info5 1 q f j j 4 r g j n and then send it to the mail id mail@xyz.com via lotus notes.

Please help me out for this one.

Thanks in advance
Ravi!