Hello,
I would like to send a email to the following people from this excel file. but I have no idea how I would get started… Could someone help me? Here is a example and there are also duplicates. Also the usernames have a email to there username linked in outlook.
Kind regards,
ukjtenhoven
Hi @ukjtenhoven,
keep your data in excel sheet then use read range acitivity to read.
after you read use this command.
String emails = string.join(“;”, for each r in dt select r(“c”))
dt → your data table
c → your column name
Hi @ukjtenhoven
Kindly follow the below steps that could help you resolve this issue buddy
–use excel application scope and pass the file path as input
–use read range activity and get the output with a variable of type datatable, named outdt
–Then use a remove duplicate rows activity and pass the input as outdt and get the output variable of type datatable with a variable named Final_dt
–then use a for each row loop and pass the input Final_dt to this activity
–inside the for each row loop use a if condition to check whether the row has empty value in the column C
like this
Not String.IsNullOrEmpty(row(“C”).ToString)
if this condition gets passed it will go to THEN part of if condition where you can use
send outlook mail activity, and mention the body of the mail, subject of the mail and in TO property mention the value as row(“C”).ToString as it has the email address to whom we want to send
Thats all it will send the mail to all the recipients in the column as for each row loop will iterate through each row one by one in that column
Cheers @ukjtenhoven
can you try with this
From r in DT select r.item(“C”)
in case if you have any duplicate values then use below
From r in DT select r.item(“C”) distinct
Hi @Palaniyappan,
So I have this now:
But I get a error could you show me how to solve that one?
Kind regards,
ukjtenhoven
use like this in the for each row loop buddy where mail_Id is the string variable that will have the mail id
Cheers @ukjtenhoven
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.
ashokkarale
lrtetala
postwick
Julian_Muhlbauer
Yoichi
Ajay_Mishra
Anonymouss
vrdabberu
ABHIMANYU_THITE1
anjani_priya