alternative
(note in test.xlsx i had to change your emails to valid emails e.g. oliverATyahoo to oliverAT@yahoo.com or else it will throw error)
test.xlsx (9.7 KB)
Main3.xaml (12.9 KB)
Convert_DataTable_X_HTML.XAML (13.2 KB)
1. uniqueCreatorList (list of string variable) = dt.AsEnumerable.Select(function(row) row("Created").ToString).Distinct.tolist
'this means get all unique creators of datatable`
2. for each creator in unique creator list
Send email:
a) to = unique Creator
b) cc = String.Join(";", dt.AsEnumerable.Where(function(row) row("Created").ToString.Equals(currentCreator)).Select(function(row)
row("Assigned").ToString))
'this means get all assigned email where creator = current creator
c) use Convert_DataTable_X_HTML.XAML to convert
dt.AsEnumerable.Where(function(row) row("Created").ToString.Equals(currentCreator)).CopyToDataTable
to string dtHTML
'this means get table where creator = current creator
body = dtHTML
input (test.xlsx)
Result
1.
