Solved: Using 2 queries for Email Output

Anonymous · ‎08-16-2021

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 · ‎08-16-2021

Hi @Anonymous ,

Please try below code

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

If this post was helpful or you need more help please consider giving Thumbs Up and Tag me in your reply I'll be happy to help. If this post helped you solve your issue please click Accept as solution and provide Thumbs Up. This will help others find it more readily.

View solution in original post

PG_WorXz10 · ‎08-16-2021

Hi @Anonymous ,

Please try below code

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

If this post was helpful or you need more help please consider giving Thumbs Up and Tag me in your reply I'll be happy to help. If this post helped you solve your issue please click Accept as solution and provide Thumbs Up. This will help others find it more readily.

Anonymous · ‎08-23-2021

Worked Perfectly!

Thank you!

Using 2 queries for Email Output

Helpful resources

Register for a Free Workshop

Microsoft Build is May 24-26. Have you registered yet?

What difference can a User Group make for you?