Reading Excel and write into gmail body

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

@Saran

  1. Read data from excel file and will give you output as DataTable.

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