Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
The #1 reason QlikView customers adopt Qlik Sense is a desire for a modern BI experience. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

Using a Text Object to send Email with Information in the Body

Hello Community.

I am having a unique issue with the 'Action' command for sending an email to Outlook.

I am intending in sending the "Mail to", "Subject", and "Body".

In the Body I am attempting to add xml links to files on one of our sites. The issue I am having is that some of the xml links have spaces in them and when I bring them in that way they do not become hyperlinks in the email (Outlook). The end user can simply copy the entire thread and paste into the browser but I would like for them not to do that for the ones that are hyperlinked. 

I found a way to append "%20" to the links using Alteryx, and the Action command is opening the Outlook email well but the hyperlinks are still split in two (i.e. is not recognizing the %20 I added). 

I have a text box with the exact same formula and I do see the right hyperlink string as intended in there! 

SOo Iam dumbfounded as to why it is not recognizing the appropriate field being sent to email?

I truly hope I have explained myself well, I also have the links to the previous threads I referenced to get me to where I am. 

https://community.qlik.com/t5/QlikView-Scripting/Send-Mail-from-QlikView-with-table-in-the-mail-body...

Thanks beforehand team. 

Labels (3)
1 Reply
Highlighted
Digital Support
Digital Support

This is most likely due to Outlook preventing things, as it is looking at things as SPAM etc...  The only thing of which I can think would be to use actual HTML markup in the Body of the email, but I am not sure how that is going to come out in the backend, as Outlook may take an even bigger exception to that.  

Another idea might be to provide a UNC file share path to a Doc or something that has the links in it instead of the links in the Email itself.  I think I would probably try the HTML markup though to see if Outlook will look more kindly at that.  You did the right thing trying to do the encoding of the space etc., but I am not sure why things are not working, best bet would be Outlook outsmarting you and trying to prevent it etc.  Hopefully this gives you an avenue to look into, if you do find a decent workaround, consider posting what you did, and you can use the Accept as Solution button after you post to mark that as the solution too.  Sorry I do not have anything better for you.

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.