Home > Blockchain >  Replace text in Outlook template before being displayed
Replace text in Outlook template before being displayed

Time:08-27

I created an Outlook template in which I want to replace certain parts.

This works if I .display the template before replacing the information.

If I replace before displaying, it only replaces some of the information.

Below is a section of my code:

With Email

    .To = AppLog.Cells(BatchRow, 23).Value
    .Subject = Replace(Email.Subject, "<Service>", BatchServiceNumber)
    .Subject = Replace(Email.Subject, "<BatchNumber>", BatchNumber)
    .HTMLBody = Replace(Email.HTMLBody, "%Examiner%", AppLog.Cells(BatchRow, 22).Value)
    .HTMLBody = Replace(Email.HTMLBody, "%Service%", BatchServiceNumber)
    .HTMLBody = Replace(Email.HTMLBody, "           
  • Related