Getting user info from Sharepoint list and pasting to email

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:

  1. 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.
  2. 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?