Replace text in email body from the excel

Hello Everyone,

I need help for the few requirement to send email from Excel, i have macro to send sheet as email, but in the sheet i need to replace few text from the cell which mentioned in the another sheet.

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

Attached macro file and screenshot for reference

Regards,
krishakAttachment 21573

Cross posted and answered at https://windowssecrets.com/forums/sh...from-the-excel
Please do not multi-post without cross referencing.