Auto email

Hello Everyone,
I hope You all are well

My today’s Query is all about Email

I have an excel sheet in which have some data

master (Student)
sample (student1)
master.xlsx (10.1 KB)
sample.xlsx (17.1 KB)

Now I want to mail new student id which are add in master sheet.
for the reference I shared the bot.
add data from another sheet with status and increment.xaml (18.6 KB)

First please run this bot so that you can understand What I want to say.


How about put SendMailMessage activity in the following If-Then, because It seems the IF activity checks whether new student or not?


not working

Hi @lakshya_garg1

The screenshot which given by @Yoichi should work. Can you tell me what error/issue that you are facing while running the flow?

Row2(“Email”).ToString → this is already holding the email value and we need to add ‘Send Outlook Mail Message’ activity after the ‘Add Data Row’ Activity to send email(s)

Thank you.