Sending Mail to multiple users with attachments v2

[ukjtenhoven (Kees-Jan)]

Hi,

Can someone help me perhaps. I want to make a robot that can read a excel file and based on that content, sending a email to them

Here is what I got so far:

but I keep getting a error:

Cheers,

[Palaniyappan (Forum Leader)]

Hi
Kindly check whether the Addheaders is enabled in read range activity buddy
or use column index for that column and usually the Column index of column will start from 0 for

Cheers @ukjtenhoven

[AnandKumar26 (Anand Kumar)]

@ukjtenhoven

Can someone help me perhaps. I want to make a robot that can read a excel file and based on that content, sending a email to them

Here is what I got so far:

Hi @ukjtenhoven - Please check, is there a column name called “C” in your input? Or check whether you checked “Add Header” in Read Range Activity.

Thanks,
AK

[ukjtenhoven (Kees-Jan)]

hi @Palaniyappan,

AddHeaders is enabled and what do you mean with the row index?

Cheers,

[ukjtenhoven (Kees-Jan)]

Hi @AnandKumar26,

yes Addheaders is enabled and it looks like this:

Cheers,

[Palaniyappan (Forum Leader)]

Sorry typo mistake, thats column index,
we can use column index like row(2) instead of row(“C”)
here i mentioned as 2 as the column index for example, it usually starts from 0
Cheers @ukjtenhoven

[ukjtenhoven (Kees-Jan)]

So I need to replace all the “C” with “2” right?

Cheers @Palaniyappan

[Palaniyappan (Forum Leader)]

yes if the column “C” is third column then replace with like this
row(2).ToString

Cheers @ukjtenhoven

[ukjtenhoven (Kees-Jan)]

It is working but it’s not removing the duplicate names . So it sends email again and again and again. Do you know how to fix that perhaps?

Cheers @Palaniyappan

[Palaniyappan (Forum Leader)]

Remove duplicate rows should remove them
What is the variable name of read range and remove duplicate rows in your workflow
Cheers @ukjtenhoven

[ukjtenhoven (Kees-Jan)]

ehmm the output from the read range is: outdt and the input from the remove duplicates rows is: outdt and the output is: Final_dt

Cheers @Palaniyappan

[Palaniyappan (Forum Leader)]

That should actually work, strange
fine lets check the value of the datatable after the remove duplicate rows
–use a output datatable next to remove duplicate rows and pass the input as Final_dt and get the output with a variable of type string named out_text
–use a write line and pass the input as out_text which would print the output of the datatable after removing the duplicates, as a string
Kindly share that screenshot buddy
Cheers @ukjtenhoven

[ukjtenhoven (Kees-Jan)]

Still not working… everything is the same still.

[ukjtenhoven (Kees-Jan)]

but it only needs to remove the duplicated rows of the names, right now it gives a output of the whole excel file.

Cheers @Palaniyappan,

[Palaniyappan (Forum Leader)]

The reason why this didnt get filtered with duplicates…is that each row with each column has some distinct values in it…thats why…
Fine
Which column you want to remove with duplicates
Cheers @ukjtenhoven

[ukjtenhoven (Kees-Jan)]

Only from Colum C Right now I have this:

the problem is that the remove duplicates range is not working.

Cheers @Palaniyappan,

[ukjtenhoven (Kees-Jan)]

Nevermind I fixed It I added the other Remove Duplicate rows and I selected Column C.

[Palaniyappan (Forum Leader)]

Well that was actually suggested here

@Palaniyappan

Remove duplicate rows should remove them
What is the variable name of read range and remove duplicate rows in your workflow
Cheers @ukjtenhoven

[ukjtenhoven (Kees-Jan)]

Oh that’s my mistake I thought it said Remove Duplicate Range

Cheers @Palaniyappan,