Hi Harshita Aralikatte Ramesh,

The error occurred due to providing wrong column name, make sure to provide correct column name which contain mail ID's.

(For Ex- in my case, I provided column name (Gmail) -> ​vCurrentRow["Gmail"].ToString()

Please let us know if it works.

Thanks

Thanks for your Reply, I tried this step. In Send Outlook Email Getting an Error.(Type: Arguement Exception, Message: The column 'Email' doesn't belongs to table)

Hi Harshita Aralikatte Ramesh,

​ You can follow following steps, depending on the use case and specifications.

Firstly, open the existing excel file by using the Create Excel Application command. Then, use the Excel Get range command to get the range from the targeted workbook and store in a datatable variable.

Once the datatable is generated, you can use the datatable commands to interact with the values you need. For example, using the for each loop command, you can iterate a data table by rows. Use the Set Variable command to store the current row value for a particular (Mail) column Name. Inside the loop you can perform other actions, like send Outlook Email to the extracted Mail cell value

By following above steps, you can send outlook mail to everyone in excel sheet.

Now, if your use case requires to look for the specific value based on input data, you can use the Lookup DataTable command to search for a value inside the datatable and return the datarow containing the cell. If the target column is set, it also returns the value of the cell from the specified DataRow.

Thanks