Hi Team,
I have a variable called Missingfiles which contains all the missing files name in it.
How can i pass this variable name in config file for email body ?
Hi Team,
I have a variable called Missingfiles which contains all the missing files name in it.
How can i pass this variable name in config file for email body ?
Hi @Shivam_Rana
Missingfiles
variable. For example, you can use {MissingFiles}
as a placeholder.Read Range
(for Excel) or Read CSV
(for CSV files) to store the data in a DataTable variable, let’s say configData
.configData
DataTable. You can use a specific row index or a specific column name to access the value. For example, assuming the email body column is named “EmailBody” and it’s in the first row, you can use configData.Rows(0)("EmailBody").ToString()
to retrieve the value.{MissingFiles}
in the retrieved email body with the value of the Missingfiles
variable. You can use the Replace
method or the String.Format
method for this.For example:
Dim emailBody As String = configData.Rows(0)(“EmailBody”).ToString()
emailBody = emailBody.Replace(“{MissingFiles}”, Missingfiles)
Thanks!!
Thanks it worked
Would you please Mark as solution if it’s worked for you.
Thanks!!
sure will do
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.