Reading excel sending email issue

Help Activities
, ,
1

Hi All,
i want to this excel and want to send email to the person mentioned in list.

image
image1166×169 31.4 KB

i want to read To,CC, Subject,Body,Attachment

how to achieve

2

@RAKESH_KUMAR_Tiwari

Use Read Range activity give your sheetname, Range, Datatable variable

Now use For Each row activity and give your datatable variable here

Inside the For Each row place Send Outlook message if you are using Outlook or Send SMTP activity if you are using any other mails

Now to get the To use CurrentRow(“To”).ToString
Like wise others

Hope this may help you

Thanks,
Srini

3

Hi @Srini84 ,

it is sending email, but not in order, why?

it sending like 2nd row first then 1st row and then 3rd row

4

@RAKESH_KUMAR_Tiwari

Check the datatable Variable which order you are getting

Run the workflow in debug mode put a breakpoint at For Each Row

Now check the datatable variable data in Local pane

Hope this may help you

Thanks,
Srini

5

ok,

just one small question, i have extarcted the data which has empty row and also have data after empty row, i want to remove it, that’s it. img for reference

image
want to delete these two row.
how to configure

image
image816×567 12.9 KB

6

@RAKESH_KUMAR_Tiwari

You can use filter datatable and write the column name in column and in operation selection is not empty

So empty rows will excluded

Hope this may help you

Thanks,
Srini

1 Like