Macro to send emails by selecting template from particular sheets

[krishak77]

Hi Everyone,

Can anybody help me to create macro as per below requirements

1) i need to send email notifications to customer, with the template of particular sheet
2) As per email id, order number, sheet name mention in column A,b,c
3) In body of mail need to select sheet which is mention in the column Sheet Name and need to replace order number which is mention on the column order number.

Thanks in Advance
Anantha