I’m trying to build a system that will go from excel and send an email out daily that would look like it gets copied and pasted into an email, while excel is still open as it’s a shared file and always has someone in it. Does anyone know class for this.
You can ready the excel data by keeping read only flag enabled in the excel scope properties panel
Then once the data is reqdinto datatable you can convert the datatable to html string using creqte html content which can be used in the send email activity to send the email with table…
If you need any specific formatting then create html content will gives options to create table as you need as well