Get the Email ID based on Short ID or name


I have a list of names in a excel file, from which I need EMail ID’s.

For ex: If i give input as ABC, DEF, bot needs to return that email id that exist in Outlook Server/Directory). How to do this?



So if you are passing DEF it should return from the server. Is that the requirement?

YEs @Rahul_Unnikrishnan

Did you try we using contains?? For example Emailid.contains(”DEf”) as a condition of IF AND get the value of Email id