Customizing output of the Read from table command

1

Hello everyone,
Can you please help me, is it possible to somehow delete the quotes that separate rows in my Datablaze table?
image

My goal is to input several emails from my datablaze table to the Gmail letter, with one snippet, and these quotations marks make it impossible to do.
Here is my snippet

{note}{dbselect: SELECT Email FROM `NOVOTEST Clients`; space=1AWQohMnJ84AhfP7gC3CyL; menu=no; multiple=yes}{endnote}
{=email}

Or how can I highlight the full column in my data blaze table and copy its contents?

Thanks.

2

Hello, welcome to the community forum!

You can edit the way your information from Data blaze is displayed to achieve this. In this case your data is in a list. You can read about editing lists here. For your case, this should work:

{note}{dbselect: SELECT Email FROM `NOVOTEST Clients`; space=1AWQohMnJ84AhfP7gC3CyL; menu=no; multiple=yes}{endnote}
{=join(email, "BLAZE_AND")}

This will input your email, separated by a comma, with "and" at the last entry. You can replace the second parameter of "join" to any separator you wish.