Subject and body of mail from excel

Help
1

Hi All,

I am having one excel file where i am having subject and body of mail in Email sheet, i want to pass those into send smtp, as subject of mail and body of mail,

Can you please tell me how i can get those value in variables.
Input file.xlsx (12.5 KB)

2

@amruta_pawar The Header format doesn’t seem to be in the right way o access the values :sweat_smile: , Do you need the Excel Format in that way itself, and can you tell me the reason why if possible?

3

yeah same format it is as per requirement, can we select text from data table where item = body, like that something, as you are good in linq, but if it is not feasible will try to ask BA to change it.

4

->Read that excel file you will get data table
->loop that data table and check
->if condition row(Item)=“Suject” then take assign activity and store row(“Text”) into an variable and
→ check another if condition for Body same as above.

3 Likes
6

only one

7

@amruta_pawar if it is only one After reading the Excel into a Datatable. Try getting the values using the Datatable itself in this way, say DT is your Datatable :

DT(0)(“Text”).ToString for Subject
DT(1)(“Text”).ToString for Body

2 Likes
8

yeah this can be good idea, but can you tell me what dt(0) mean, is it row?

1 Like
9

thanks buddy , it will work too. :slight_smile:

10

@amruta_pawar DT(0)(“Text”) means that you are accessing the First row value of Text Column in that Datatable.

1 Like
11

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