Macro to Send a email using Excel data via Outlook

[Sri.n]

Hello All,

I am new member here,

I do an repetitive work where I need to filter the Customer number and paste the data to an Email then send. is there any Macro where I can input number and the excel populate the data and copy the cells to new outlook email.

The data (rows) may vary but Col will remain same.

also can this be looped if I give more than 2 customer numbers can this take and do the same job.

attached is the sample sheet for reference.

Your help matters a lot to me.

Thank You

 

[Deepak]

Check this.

 

[Sri.n]

Hi Deepak. This is really wonderful.. I can amend the code.'

Thank you so Much