Send mails from spreadsheet


#1

Hi

I am trying to send emails to users in our organisation. Their email addresses er generated in a spreadsheet, and i have created a variable I am trying to use to send the email (the variable is called “samlet E-mail”)

Screenshot_1
Screenshot_2Screenshot_3

But it doesnt work with the variable? Should I make it as a semicolon seperated file? I dont know if its because the robot cant read it from the excel file


#2

Hi @Kekth,

Refer this post.

use Read Range activity to read the all the mail and get it into datatable

arrvalue=(from line in Dt.Select select Convert.ToString(line("samlet E-mail"))).ToArray()

strMailId=string.join(",",arrvalue).Replace(",",";")

use strMailId in thesend SMTP mail message properties To

Regards,
Arivu


#3

I dont understand where you want me to insert this??
[/uploads/uipath/original/2X/3/3057b180ed461408689ee88c6adb988370652553.png]

Do I need to define new variables and insert somewhere? I don’t know how to set it all up.