How do i read from a single cell in excel for email and send in outlook?

Hey guys, im kinda stuck how do i read a single cell in excel for the email instead of reading the entire column because that is what it is doing now with this


An example of reading the single cell


Follow the below steps,

  1. Read the excel file.
  2. In ‘To’ field give like this, yourDTVariable.rows.item(0)(“Email”).ToString

Feel free to reach us at any time if you have doubts. Thanks.

Happy Automation


You can use read cell and store it in string and pass it into mail activity…thanks

Ohh thanks but not as string but generic value works

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