Hello All, i have a task that is:
-check the email inbox ( Your Mailbox)
-if the email has the following criteria:
sender exist on the excel sheet &
email subject is “Test Bot”
1-the bot will open the browser and navigate to the corresponding url based on the sender
-else - if the sender does not exist in the excel sheet, he will receive and email that “you are not authorized to perform this task”
2- create a txt file, name it with the sender name + the current date and time,
3 write inside the file “ Successfully navigated to (the URL that belongs to the user)”
4 store the text file in a predefined folder
5- send a success email with txt attached
So,my program works but i have a logical error from the for each row activity, since iam looping for each name, if i find the sender then proceed correctly, but the robot will then go over the names and reply to my sender that he is not authorized, how can i stop this from happening ?
Excel file looks like
Sender URL
John www
Alex www
Sam www
So if sender is john and subject is correct i retrieve the URL and send john the attachment, but the i send john 2 emails because the next two rows dont match.
Any help ?