Hi, I want to extract few columns from excel and write those into gmail body and send it to concern persons. Pls suggest me how to proceed
-
Read data from excel file and will give you output as DataTable.
-
And then use Output DataTable activity to convert DataTable into String and then pass it to body section in Gmail to write into it.
1 Like
Fine
to get the required column we want we can use this expression
yourdatatable = yourdatatable.DefaultView.ToTable(False,“columnname1”,“columnname2”).Copytodatatable()
then to send them as mail with table attached in body
this thread would help you resolve this
Cheers @Saran
1 Like