Mail attachment through EXCEL

[ravirmn]

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:







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





and then send it to the mail id [email protected] via lotus notes.


Please help me out for this one.


Thanks in advance

Ravi!