Reading Excel and write into gmail body

[Palaniyappan (Palaniyappan P)]

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

How to write excel data in outlook mail?

Hi @igul, Try this solution and change according to yours. Just change the fields as per your column index and i have used outlook here. This is just a rough solution you can try exceptions and make the code more reliable. How to: Read the whole data to a data table using Read Range Activity. Use For each row activity and read in loop. Assign to variables the fields by row index. Attach email app(outlook) then use selectors for the To,Subject and message fields. Type Into and click on send. …

Cheers @Saran