I have an excel:
column 1 Column 2 Column 3
Row 1 123 abc xyz@gmail.com
Row 2 143 gvf qwe@gmail.com
Row 3 123 hgf xyz@gmail.com
I want to send an automatic email to 123 having details contains in row 1 and 3 and then automatic email to 143 having details in row 2.
Kindly help me with this.
skini76
February 12, 2019, 7:04am
2
Sort the excel by Column 3, then use for loop, following is the logic
for (i = 0; i < Dt.rows.count < i++)
{
email = Dt.rows(i).items(2).tostring
msg = “”
while ( Dt.rows(i).items(2).tostring == email)
{
msg = msg + Dt.rows(i).items(1).tostring //construct the message
}
sendmail (email , msg) //code to send mail
}
Can you please share a sample?
@skini76 can you please share workflow sample?
@igoike and @lukas_krishnan can you please help?
@bagishojha can you please help?
bagishojha
(Bagish Ojha)
February 18, 2019, 1:34pm
8
Hi Please check this.
I think this will help youMain.xaml (8.1 KB)
@bagishojha This will work when I have only 2 entries like 123 and 143. but I have a lot of entries (like 123, 143, 156 and 354 so on). can I make it dynamic?
bagishojha
(Bagish Ojha)
February 20, 2019, 12:47pm
10
Yeah You can use there switch if your sheet column value is static.
Shared workflow didn’t work.
nimin
(nimzz)
February 24, 2019, 7:54am
12
Hi @kapildarmoda ,
Please check this workflow. Email_Auto_MailList.zip (19.4 KB)
Warm regards,
Nimiin
@nimin thanks for your efforts but it didn’t work the way I wanted.
nimin
(nimzz)
March 2, 2019, 7:57am
14
Hi @kapildarmoda ,
The above workflow send mails with Subject, contents and mail address specified in corresponding columns. If multiple email address are found, it concatenates all contents for that address and send at once.
Could you please elaborate your requirement?
Warm regards,
Nimin
@nimin i want to send data in table format.
@nimin Hi Nimin, your workflow worked well after a little bit of modification. but the output is not formatted. please find below desirable output:
Email Body:
Hi ABC,
Please find below detail:
Regards,
Team 1
can you help me with this?
@nimin emphasized text I am getting this error. can you plz help?
@nimin @bagishojha I am attaching following documents:
workflow
input excel file
actual intermittent output excel file which is going in email body
Desired intermittent output excel file (actual) which is going in email body.
rest all things are fine…can you plz help?
Main - Feedback Loop_05-03-2019.xaml (76.1 KB)
Actual Feedback12345.xlsx (8.0 KB)
Desired Feedback12345.xlsx (8.0 KB)
Mail_List.xlsx (9.6 KB)
@reda @alialroomi @Mohan_R hi team, can you plz help in above problem which I just posted.