Can anyone please help me to copy the following datatable to email.
I want to exclude the 1st row (column0, column1…) in the email. Also i need to copy columns from 0 to 7 only
I tried multiple times. But not able to get a proper format. check.xlsx (11.3 KB)
I am getting the output in mail as shown in image-2
But i need as its in image 3
eg: In 3rd column , the 2nd occurrence of CINV… (marked in red line)should start on next line in the same row
Is there any modification that i should do in the expression(image attached for it)
Sorry for the delayed response. I got stuck in the middle of the code and was unable to reach the mailing part. The requirement was changed.
Please can you help me with this Excel_Data.xlsx (11.3 KB)
I have a excel file which has 2 sheets; employee details and mail IDS
for each row in employee details, it should check if the name matches with name in mail ids sheet, if the name matches it must extract the corresponding mail id and mail the whole row from employee details to that ID in the form of a table