hello uipath
I need to extract the data from excel after that I get some error if the email id is not correct i get the error so am using try-catch to the normal flow after that I need to update the status column like mail not sent who has email is send properly I need to write in the status mail sent how to do that one can anyone know please let me know its help me
Instead of three activity (assign, add data row, write range) in catch section u can use write cell activitiy with cell value changing dynamically.
In the for each row property panel there is index property , create a varaible there let’s say index which stores the row index of each iteration in datatable.
So in try section if the mail is sent properly then u can use use write cell activitiy to update the status with cell as “D”+(index+2). ToString with cell content as “Mail sent”
so in catch section use same write cell activitiy instead of assign, add datatrow , write range activity in catch with cell as same as specified in the above write cell but with different cell content as “Mail Not Sent”
sure I am using g suite MAIL
Actually, before its working fine only when I use write cell activity in that from that time i get an error and I remove the write cell activity still I get an error in that
Thank you very… much i get the solution and thanks for your valid time i use this bellow activity and thank you also @NIVED_NAMBIAR You both help me a lot Uipath.Email.Validation.Activities