I’m doing a simple exercise of extracting data table using Table Extraction from a website then send an email containing the table. I have no problem in extracting the table and saving it inside the project notebook excel file: nothing is missing including the header. But if I extract the table, save it as a variable then use it directly in the Send Email activity (Body: HTML), the header of the table is somehow missing. Sure I can do a turnaround by sending the table as attachment instead, but I’m just wondering if there’s an explanation on the missing header.
Hi @kumar.varun2 . No, it is the HTLM editor in the Send Email activity.
Hi @NIVED_NAMBIAR I don’t know if there is a conversion happening. What I did is just using The Table Extraction wizard, add data, select one column of the table, then preview the table. As you can see, the header is still there in the Preview.
Hi @Luis_Fernando, I’ve faced the same header issue with Create HTML content activity while sending a table in mail body. Here is the work around I did to fix.
Once you have the datatable that needs to be sent in mail (Ex: dt1)
Write it to a excel sheet using write range activity (Enable “Add Headers”)
In very next step, do a Read range (Disable “Add Headers”) and store it in a different variable “dt2”
Now, pass this dt2 in your Create HTML content activity and try sending it in the mail body.