From Excel Datas to E-mail Html Body

Hello all,
i want to send a table as you can see the picture below. It should be seeing like that.
table
and my excel is like that.
my_excel

I’m using send exchange mail activity. Can you help me how can i do like that and if it is possible can you explain step by step. And also i have more than 1 sheets.

Thank you.

Hi @yigit.aybey ,

Check the Below Post which helps you in Conversion from Datatable to Html Table format :

The Output would be a String which you could then use to append to the body of the mail.

The Configuration of the Send Exchange Email Body Activity Should have Property IsBodyHtml Checked (Enabled).

2 Likes

I got this error.


my code

my_table => Read Range output variable
Read Range => Reading excel files

@yigit.aybey , In the R.H.S of the Assign Activity remove HtmlBodyStr=

1 Like

it worked very well.
thanks for your help.

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.