Email from .net script
We are sending email from workbench using .net script. We would like to include the value from active data sheet in subject like.
Can anyone help us how to do it. below is the code i tried which is not working.
Dim row As ActiveDataRow
mail.Subject = "This is an email Karthick" + row.GetString("O_Order_Number")
RE: Email from .net script
row variable in your code is not assigned any value and will not return any string.
Try something like this to read the cell "O_Order_Number" from the first row of your Active Data file:
Dim data As ActiveData = Workbench.LoadActiveData("RPA_Order_Creation") Dim row As ActiveDataRow = data.Item(1)
mail.Subject = "This is an email Karthick " + row.GetString("O_Order_Number")