PDA

View Full Version : Mail attachment through EXCEL



ravirmn
05-05-2013, 09:39 PM
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 (mail@xyz.com) 1 q f j j 123@xyz.com (123@xyz.com) 2 w c h j abc@xyz.com (abc@xyz.com) 3 e c h n mail@xyz.com (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!