I'm using Outlook VBO
Created instance and using send email action
I need to send an email with a table that consist of values in the collection.
Here's an example of my collection
Column1 | Column2
---------------------
ABCDE | ABCDE
ABCSS | ABCDE
ABCAA | ABCDE
I'm using calculation stage to do this. This is my HTML code.
"<table>" &
"<tr><th>Column1</th>" &
"<th>Column2</th></tr>"
& Chr(10) & Chr(10) &
"<tr><td>" & [Collection.Column1] & "</td>" &
"<td>" & [Collection.Column2] & "</td></tr>"
& NewLine() &
"</table>"
When i put it in a loop, the first row is overwritten by the second row of the collection.
In the end, i only have 1 row of value even though i have 3 rows
Does anyone knows how to get all values in a collection in a table?
Thanks!
Created instance and using send email action
I need to send an email with a table that consist of values in the collection.
Here's an example of my collection
Column1 | Column2
---------------------
ABCDE | ABCDE
ABCSS | ABCDE
ABCAA | ABCDE
I'm using calculation stage to do this. This is my HTML code.
"<table>" &
"<tr><th>Column1</th>" &
"<th>Column2</th></tr>"
& Chr(10) & Chr(10) &
"<tr><td>" & [Collection.Column1] & "</td>" &
"<td>" & [Collection.Column2] & "</td></tr>"
& NewLine() &
"</table>"
When i put it in a loop, the first row is overwritten by the second row of the collection.
In the end, i only have 1 row of value even though i have 3 rows
Does anyone knows how to get all values in a collection in a table?
Thanks!