Group datatable by EmailId and send mail seperately

Help Forum
, ,
1

Hi everyone,

with reference to this

after that i need to group the datatable according to emailId and if there are two rows belongs to same emailid , i need to create a html table

So how to group them by emailId and get seperate datatables so to create html table

@Yoichi @Palaniyappan @ppr
thanks in advance

2

some sample date input / expected out would be helpful. In general, we would group the data and return a list of data tables

TableList | List(Of DataTable) =
(From d in dtData.AsEnumerable
Group d by d(“Email”).toString.Trim into grp=Group
Select t = grp.CopyToDataTable).toList

3

as seperate datatables to create html table and attach in email

@ppr

4 
TableList | List(Of DataTable) =
(From d in dtData.AsEnumerable
Group d by d(“email”).toString.Trim into grp=Group
Select t = grp.CopyToDataTable).toList

then iterate over the table list - for each activity | TypeArgument: DataTable and:

  • prepare the email - for datatable to HTML Table we can use activities from the marketplace or the Create HTML Content Activity
  • send the email
1 Like
5

@ppr it worked thank you!!

6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.