I need help in the excel automation

[copy_writes (chethan)]

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

I hope I will get a replay from Uipath family

Thanks
Chethan P

[NIVED_NAMBIAR (NIVED N)]

Hi @copy_writes

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”

Hope it helps you

Regards

Nived N

Happy Automation

[copy_writes (chethan)]

Hello Thanks for your replay I get an error wen am using write cell inside try-catch like this bellow

@Palaniyappan @loginerror @Pablito please help me

[NIVED_NAMBIAR (NIVED N)]

Hi @copy_writes

I think it is not the issue with write cell

It is the issue with the send messages activity

So can u show for which email u are getting this error?

[Karun (Karun Kumar Nalam)]

Hi @copy_writes,

I guess the error is due to flower brackets ‘{’, in To field of Send message activity.
Please remove the brackets and try.

[copy_writes (chethan)]

No, actually it will take like that only array form only

[copy_writes (chethan)]

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

[Karun (Karun Kumar Nalam)]

Hey, you’re facing this error because of invalid input data,
the first email id is invalid, it has two ‘@’ characters.

you need to check it whether the given email id is valid or not before passing it to send email activity, look for that logic.

And also you’re looping each record (each email id) then no need of array in TO field of send email activity , I guess you can make some modification.

Thanks

[copy_writes (chethan)]

Thanks for your Replay
I know that is invalid input but the thing I use try-catch activity to handle the error

you need to check it whether the given email id is valid or not before passing it to send email activity, look for that logic

any logic is there for this

Thanks
Chethan P

[copy_writes (chethan)]

If i not given that {} it show an error

[Karun (Karun Kumar Nalam)]

Yes,

How to check whether a E-mail address is in correct format?

Hi Guys, I am facing a challenge now. So here’s the thing. We have a user list with contacts such as phone number and e-mail. The robot need to send e-mail to each of the users on the list. But we found that when SMTP activity faces a wrong-format address, the robot stops automatically and doesn’t report the position or record. Is there any method that I can test the format of e-mail addresses on the list before sending mails? Thanks and Happy New Year! Aaron

[Karun (Karun Kumar Nalam)]

Ok understood, actually I compared your activity with Send SMTP Mail Message.

[copy_writes (chethan)]

Still i get same error if i remove the {}

[Karun (Karun Kumar Nalam)]

The variable emailID should be 1D array only, did you declare the same?

[copy_writes (chethan)]

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