Need help in formatting mail body,Can anyone help me please

Hi @Chandini_Roy

You can achieve it by using the read range & some linq

Read the excel sheet by using the use excel file inside that use the for each excel sheet, then use read range to go through rows starting from A4 as our table start from there assuming rows will extend till 100 you can increase it anyway, we will be removing the blanks by using the linq.

if we found out that there is data below the 4 rows we will sending a mail as you need some formatting in the mail i have use Create HTML Content & passed the datatable

& finally pass the HTML content to body of the mail activity.

Your output will look like this

I did not got where you took the start & end time but i guess that is easy part you can figure it out,

Hope this helps :slight_smile:

File for your ref-
Excel_Row_Format_Mail 1.zip (18.7 KB)