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.
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
Use for each row and inside the body use datatable.Rows(0)(0).Tostring . so you will get A2 cell
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
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
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.