How can I find E-Mail-Adresses from each single cell of an Excel file?

Help Studio
, ,
3

Hi @111531
Try this way

  1. Use assign activitiy to intialise int32 varaible
    counter=1

  2. Read the datatable and store in dt1 using read range( I think there is no headers for the excel data as per the figure. So please untick the Add headers option in read range)

use for each row to loop through dt1

inside the for each row do the following:
1. Assign activity:

                   email = System.Text.RegularExpression.Regex.Match(row(1).ToString,"(?<=Email:).*").Value

  1. Now use write cell activitiy with details as below

                   filepath :
         
        Sheet Name: 
         
         Cell : "C"+counter.ToString
           
          Value : email

  2. Now use Assign activitiy again to increment counter by one

              counter =counter+1

  3. Now u can use outlook mail activivty to send email to that email by using email

  4. Finally outside the loop, use write range activivty to write the updated datatable to excel

Regards

Nived N
Happy Automation

2 Likes