Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Trying to allow the user to send their results from our QS application back to an Outlook mailbox as we have a requirement for gathering results and this is the best option I know of.
Using the mailto command and can successfully glean the data from the user's selections and format an email to the Outlook mailbox. The issue I'm having is if there's a way to help format the email with control characters to make more readable.
I can get the text selected but it is running together. Does anyone know what will work in Qlik Sense mailto logic for a control character? I have tried chr(13) and chr(10) unsuccessfully.
='mailto://first.last@domain.com'
& '?body='
& 'Vendor Type: ' & VendorType & ' '
& 'Number of Domains: ' & NumDomains & ' ' & chr(13)
& 'Does Contract Exist?: ' & ContractStatus & ' '
& 'Aggregated Data Type: ' & AggregiatedDataType & ' '
& 'Volume of Data: ' & DataVolume & ' '
& 'Impact of Loss Data: ' & DataLossImpact & ' '
& 'Total Score: ' & (ADTValue + DVValue + VendorValue) * DLIValue * (ContractValue + DomainValue)
& '&subject='&'Calculator - External entry'
Hi
I am sure this article will solve your issue.
html - Mailto: Body formatting - Stack Overflow
Basically adding these characters will insert a line break - "%0D%0A"