Mail attachment through EXCEL

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:




Attachment 99787


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



Attachment 99789

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


Please help me out for this one.


Thanks in advance

Ravi!

i guess the best way is to sort the sheet on the mail id, loop through until the id changes
or filter and send whole sheet
i have no experience with lotus notes, but it would be simple enough to send with outlook or CDO, so i assume lotus would be no harder

Welcome to the forums Ravi :wave:

I agree with Pete on sorting. You can sort the data and copy the relevant section to a new sheet and then mail those selected cells using Lotus Notes.

For sending email from lotus notes see my reply in this post.

Topic: how do i send an email from excel containing only certain cells from the workbook?
Link: http://social.msdn.microsoft.com/For...0-bfba3cf15323