How do i call html body from Config excel

[ManjunathReddy (P Manjunatha)]

html content :

"<p>Hi Team,<br><br>" &
            "Bread Pay Hubspot Account deletion Process Completed Successfully.<br><br>" &
            "No of account Deleted: " & In_No_Record_Deleted & "<br><br>" &
            "Thanks, <br>" & Environment.MachineName & "<br><br>" &
            "Date: " & now.Date.ToString() & "<br><br>" &
            "Time: " & Now.TimeOfDay.ToString() & "</p>"

[Parvathy (PS Parvathy)]

Hi @ManjunathReddy

Try this way:

Body = "<p>Hi Team,<br><br>" &
              "Bread Pay Hubspot Account deletion Process Completed Successfully.<br><br>" &
              "No of account Deleted: " & In_No_Record_Deleted & "<br><br>" &
              "Thanks, <br>" & Environment.MachineName & "<br><br>" &
              "Date: " & Now.Date.ToString() & "<br><br>" &
              "Time: " & Now.TimeOfDay.ToString() & "<br><br></p>"

In the Settings sheet give Name as EmailBody and Value as above.

htmlContent = Config("EmailBody").Tostring

' Replace placeholders with actual values
htmlContent = htmlContent.Replace("{In_No_Record_Deleted}", In_No_Record_Deleted.ToString())
htmlContent = htmlContent.Replace("{MachineName}", Environment.MachineName)
htmlContent = htmlContent.Replace("{CurrentDate}", Now.Date.ToString())
htmlContent = htmlContent.Replace("{CurrentTime}", Now.TimeOfDay.ToString())

This should help you. Make sure to enable IsBodyHTML in the properties panel Send Outlook Mail Message.

or

You can use Create HTML Content activity and write the body and pass the variables are required.

Hope it helps!!
Regards

[srinic (Srini)]

@ManjunathReddy

"<p>Hi Team,<br><br>" &
            "Bread Pay Hubspot Account deletion Process Completed Successfully.<br><br>" #No of account Deleted:# # No_Record_Deleted # "<br><br>" &
            "Thanks, <br> # Environment_MachineName# <br><br>" &
            "Date: # DATE_STRING #<br><br>" &
            "Time: #DATE_TIME_STRING#</p>"

Replace the above place holders with the values you want with string.replace

[Nguyen_Van_Luong1 (Nguyen Van Luong)]

Hi @ManjunathReddy ,
You need get html content form Config excel file
You can use html body, with value you get from argument form read config file

Hope it help

[sanjay3 (Sanjay)]

Hi @ManjunathReddy

You can create your html body in a notepad and save as a Text File
In your config File Put the path of your text(Notepad) file like this

1 col 2 col
HtmlBody - C:\yourpath\MailBody.txt

In the Send Outlook Mail Messages in the properties section checked on IsBodyHtml

Confif(HtmlBody).ToString