Consulting

Results 1 to 2 of 2

Thread: Replace text in email body from the excel

  1. #1

    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,
    krishak
    ON.zip

  2. #2
    Cross posted and answered at https://windowssecrets.com/forums/sh...from-the-excel
    Please do not multi-post without cross referencing.
    Graham Mayor - MS MVP (Word) 2002-2019
    Visit my web site for more programming tips and ready made processes
    http://www.gmayor.com

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •