Email Automation With Filtered Data

I have an excel:
column 1 Column 2 Column 3
Row 1 123 abc
Row 2 143 gvf
Row 3 123 hgf

I want to send an automatic email to 123 having details contains in row 1 and 3 and then automatic email to 143 having details in row 2.

Kindly help me with this.

Sort the excel by Column 3, then use for loop, following is the logic

for (i = 0; i < Dt.rows.count < i++)
email = Dt.rows(i).items(2).tostring
msg = “”
while ( Dt.rows(i).items(2).tostring == email)
msg = msg + Dt.rows(i).items(1).tostring //construct the message
sendmail (email , msg) //code to send mail

Can you please share a sample?

Can someone help me?

@skini76 can you please share workflow sample?

@igoike and @lukas_krishnan can you please help?

@bagishojha can you please help?

Hi Please check this.
I think this will help youMain.xaml (8.1 KB)

@bagishojha This will work when I have only 2 entries like 123 and 143. but I have a lot of entries (like 123, 143, 156 and 354 so on). can I make it dynamic?

Yeah You can use there switch if your sheet column value is static.

Shared workflow didn’t work.

Hi @kapildarmoda ,

Please check this workflow. (19.4 KB)

Warm regards,

@nimin thanks for your efforts but it didn’t work the way I wanted.

Hi @kapildarmoda,

The above workflow send mails with Subject, contents and mail address specified in corresponding columns. If multiple email address are found, it concatenates all contents for that address and send at once.
Could you please elaborate your requirement? :slightly_smiling_face:

Warm regards,

@nimin i want to send data in table format.

@nimin Hi Nimin, your workflow worked well after a little bit of modification. but the output is not formatted. please find below desirable output:

Email Body:


Please find below detail:


Team 1

can you help me with this?

@niminemphasized text I am getting this error. can you plz help?


@nimin @bagishojha I am attaching following documents:

  1. workflow
  2. input excel file
  3. actual intermittent output excel file which is going in email body
  4. Desired intermittent output excel file (actual) which is going in email body.

rest all things are fine…can you plz help?
Main - Feedback Loop_05-03-2019.xaml (76.1 KB)
Actual Feedback12345.xlsx (8.0 KB)
Desired Feedback12345.xlsx (8.0 KB)
Mail_List.xlsx (9.6 KB)

@reda @alialroomi @Mohan_R hi team, can you plz help in above problem which I just posted.