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.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?
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)