I have an Excel table which looks something like this:
I want to send an email to only those users with ‘Value = 0’. I managed to do so but the thing is the email with zero values (3 rows) is sent to all 3 users (User1, User3 and User4). What I’m after, I want to send the email with zero value only to the respective user, e.g. the user ‘User1’ will get an email with an Excel with only one row which corresponds to him/her and won’t receive the rows belonging to users ‘User3’ and ‘User4’.
Thanks Manjuts90 for your efforts providing the example, much appreciated.
A quick question, the path for the ‘Write range’ activity is: “C:\Users\Raju\Desktop\Mail"+row(1).ToString+”\Data.xlsx"
Does this mean a new folder will be created for each Excel output file? Also, how about if I want to send an email also for those having values smaller than zero (if they exist), where that condition should be specified?
Yes for each mail, folder is created. I have created folder for mail because excel file can be named properly. Without separate folder creation also u can do it, by giving unique name it must be changed while second excel file and soon. You can use Name column, Email column values.
Above statement will create excel file with mail ids(Sometimes filename should contain some special characters in that case file creation fails). So choose wisely filename while creating file.