I created a workflow wherein bot reads the excel data and then created a loop for each row.
How could I:
- Read the excel column and write sender’s name dynamically in “to” of “send outlook mail message” activity?
- copy excel sheet header and a row in the outlook mail “body” and send to multiple users (each row to each user+ header which is common for all)
Please suggest some code which could convert the datatable to string such as its tabular format is not lost. Also, Screen scraping or copy is not working for that excel sheet.