Auto email

[lakshya_garg1 (prince garg)]

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.

[Yoichi]

Hi,

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

Regards,

[lakshya_garg1 (prince garg)]

not working

[Jobin_Joy]

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.