Using 2 queries for Email Output

[nicholas93]

Hi All, 

I have 2 separate quires here that is I separate them out I can send them using the  'SendEmail' function with no issues, however, I would like to see both sets of data when I use the email function. I got this far but when I receive an email the body of the text is just 'false'. 

Any help would be appreciated. 

Thanks in advance! 

Query in question: 

Office365Outlook.SendEmailV2("emailaddress@eamil.co.uk","Subject",Concat(ListBox2.SelectedItems,'SSR Checks',",") && Concatenate(RichTextEditor1.HtmlText,""))

[PG_WorXz10 · Accepted solution]

Hi @nicholas93 ,

Please try below code 

Office365Outlook.SendEmailV2("emailaddress@eamil.co.uk","Subject",Concat(ListBox2.SelectedItems,'SSR Checks',",")&""&Concatenate(RichTextEditor1.HtmlText,""))

[nicholas93]

Worked Perfectly! 

Thank you!