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.
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