Need to check if there is a flag in my first column of excel and send a mail in outlook with the entire row

please help me i have a submission this week

Hi @poonati.p , welcome to UiPath forum!

  1. Read your Excel spreadsheet, this return a DataTable
  2. Use a For Each Row to iterate each row in your datatable
  3. To access to the value on the column 1 for the current row, you can use row(0).ToString() or by naming the column name row(“Inventory ID”).ToString(), you can apply your validation on the returned value
  4. The easy way to send all the data in the row is joining all the column values into a single separated by commas string (e.g. String.Join(",",row.ItemArray), but it is not pretty. You can define your email body according to your requirements.

Regards,
Andres

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.