topic Search for VB script for converting collection as HTML table in Product Forum

Search for VB script for converting collection as HTML table

Anonymous — Mon, 31 Jul 2023 07:59:40 GMT

Hi,

In my project I need to send a collection as an Email body table. I read some articles related to this. I have seen that it is possible with HTML table. Can anyone share a VB script for converting collection to HTML table as text?

Note that the collection row is dynamic.

Example:

Dear M,

Please find attched information.

Name

Regards,

Re: Search for VB script for converting collection as HTML table

abhinav.kumar — Mon, 31 Jul 2023 15:10:23 GMT

Hi Ekram,

you can create table row dynamically for the values available in collection as below:

Please let me know if you need any further help. Thanks

Regards,

Abhinav

Re: Search for VB script for converting collection as HTML table

harish.mogulluri — Mon, 31 Jul 2023 18:46:52 GMT

Hi Ekram,

I agree of using calculation stage to create html tags in collection,

If you have thousands of rows it will take very long time to generate html tag.

I never tried using C# to convert datatable/collection to HTML. YOu can check below code.

https://www.c-sharpcorner.com/UploadFile/deveshomar/export-datatable-to-html-in-C-Sharp/

Re: Search for VB script for converting collection as HTML table

Anonymous — Wed, 02 Aug 2023 08:45:24 GMT

Thanks to both of you for the solutions. I will take a look at these and let you know.

Re: Search for VB script for converting collection as HTML table

Anonymous — Thu, 10 Aug 2023 07:01:22 GMT

Hi @Abhinav Kumar,

I have tried your solution because I have data of only 10 rows. Unfortunately, it didn't work. Here is the screenshot:

Re: Search for VB script for converting collection as HTML table

abhinav.kumar — Thu, 10 Aug 2023 13:15:45 GMT

Hi Shihab

Please put IsHTML flag value as True and try again. Please see the below screenshot.

Re: Search for VB script for converting collection as HTML table

Anonymous — Fri, 11 Aug 2023 11:24:57 GMT

Hi @Abhinav Kumar,

If I set isHTML flag as True, it works for [the follwing code.

coll2]&" "& [Coll1.Company]& ""

Re: Search for VB script for converting collection as HTML table

abhinav.kumar — Sat, 12 Aug 2023 05:30:38 GMT

Hi Shihab,

is email is not coming in below format and also can you let me know your requirements again ?

Dear M,

Please find attached information.

Name

Regards,

Re: Search for VB script for converting collection as HTML table

Anonymous — Mon, 14 Aug 2023 11:31:09 GMT

Hi @Abhinav Kumar,

It is working right now.

If I write "</tr><tr><td>", it doesn't work. But when I write " " then it works.

Re: Search for VB script for converting collection as HTML table

jsantiago08 — Tue, 22 Aug 2023 14:48:17 GMT

Try this code stage using C#.