Hi, I want to put or Copy my excel table to my email Body.
Here is My Excel, This is Dynamic Data, sometimes its more than one or two data in the table.
I wanted to copy the table and put it in my email template.
Here is my Email Template.
My expected output should be like this.
Thank you in advance
You can follow below video
I want to achieve a task of email, below is my issue
I have an excel with column name “Name” and “Email id” and i have to send email with email body having name from the excel with my message in html format like below
On this special day, We wishes you very Happy Birthday! May you be showered with blessings and happiness!!!
With warm wishes,
I have created a flow attaching with this.
I want the recipient to receive be…
Why i am getting error in my For each
Error Says : ‘)’ expected
You can read the excel and store data in DataTable.
you can add this activity package to your project(from manage packages), which takes DataTable as input and gives result as String.
DataTable.to.HTML.String.1.0.2.nupkg (23.8 KB)
While sending the mail check
IsBodyHTML propertie like below
Try to use “for each” as shown below
foreach (DataRow row in FilteredDt.Rows)
Please use my package,
There is an activity called convert to html which has lot of customization as well
If the issue got resolved,please mark it as solution and close the thread so it may be useful to others in the future.
Im still learning this package, can you recommend me how to use this properly to resolve my issue?
@Vincent_Nuestro yes sure
Please try the below steps,
Read the data in the excel sheet using
read range and store it a datatable variable name dt.
Install the package and you will find 15 activites inside this package for now please use
convert to html activity.
datatable dt as input for the activity and store the output in a string variable named result.(create one if it don’t have already)
Use any send mail activity and
pass the result in the body in the property.
Change the font, font color,font size, header and border as you want in the
properties panel of the convert to html activity.
Please let me know if anything required.
@Vincent_Nuestro have you tried it?
Thanks for using the package, and from the screenshot I can see that the number of columns are more, because the outlook table is not having as many column size as excel,it will auto adjust to the screen size.the outlook tables has its limitations of how many columns it can display without breaking it’s structure as you have.
There are some ways we can test it,
If you can reduce some columns it will align perfectly.
If you see the table in bigger monitor instead of a laptop it will adjust the table contents to the screen size.
As for I know it will break the alignment it has more columns (also each column size is big) and see the content in small screen (like laptop)
I see, Got it. Thank you So much:)
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.