We are trying to get email from SharePoint list and then pasting it to the “To” field of the email and sending out the email.
Challenge we are facing:
- The column that we are trying to extract the email does not contain the email address. Instead, it contains the name from the active directory.
- We want the bot to copy the name but only take the email associated with it. Can the bot do that?
What’s the easiest way to do this for RPA?