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

Help Studio
1

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

image

An example of reading the single cell
image

2

Hi @SIM_JUN_HUI_BERTRAM_CSOD

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

3

Hi @SIM_JUN_HUI_BERTRAM_CSOD

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

4

Ohh thanks but not as string but generic value works

5

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