Send Mail From Excel Via Outlook With Attachment And Range As Mail Body

[Prabhu]

Hi Friends,

I have attached a workbook with 2 macro program.

Macro 1.Attachment: this macro help me to attach more than one sheets as single work book to send to particular email id given in the program.

Macro 2.MailbodyandAttachment: this macro help me to attach given(single) sheet and past given( single) sheet in the mail body.


I need a small modification in the above mentioned macro 1 i.e attachment contain more then two work sheet like macro 1 and to past the selected sheet(single) in the body of the mail like Macro2.


This changes will help me to attach more than one sheet as single workbook in the outlook mail also it will past the given sheet in the body of the mail.

Kindly do the needful to get the modified macro program.

Regards,

Prabhu