Copy the one cell data from excel sheet to our mail body

Hi,
I want one cell data from the excel sheet and it will paste in my mail body in the form of text… how it is possible…

Read the cell value using Read Cell activity. The output will be stored in to a string.

Set the body of the email to the string variable created from the Read Cell activity.

Regards,
Karthik Byggari

After Read Cell activity which activity I have to put in the workflow…??

How you are opening the mail?

can I use outlook mail activity

Hai @amala443,

Use for each row and inside the body use datatable.Rows(0)(0).Tostring . so you will get A2 cell

image

Regards ,
gulshiyaa

1 Like

Hi
hope these steps would help you resolve this
–use excel application scope and pass the file path as input
–inside the scope use READ RANGE activity and get the output with a variable of type datatable named dt
-now use a ASSIGN activity like this to get a specific cell value
str_input = dt.Rows(rowindex)(columnindex).ToString
or
str_input = dt.Rows(rowindex)(“columnname”).ToString
both rowindex and column index starts from 0 for first row and first column

and then this variable can be used in the mail body in SEND OUTLOOK MAIL activity

kindly try this and let know for any queries or clarification
Cheers @amala443

thank you all

If you find it useful mark it as solution and close the thread.

okay thank you

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