Replace text in email body from the excel

[Anantha Krishna]

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,
Anantha Krishna

 

[Luke M]

Hi Anatha,

Please take a moment to review the forum rules. You have cross-posted your question w/o providing links to the other sites, which is a direct violation.

Other posts:
Replace text in email body from the excel
http://www.vbaexpress.com/forum/showthread.php?61961-Replace-text-in-email-body-from-the-excel
Replace text in email body from the excel | Windows Secrets Lounge
https://windowssecrets.com/forums/showthread.php/195931-Replace-text-in-email-body-from-the-excel