topic Re: Email hyperlinking? in QlikView

Email hyperlinking?

Wed, 20 Jun 2012 20:11:15 GMT

Is there a way within QlikView to post an email address that when clicked, opens up an Outlook email to send to that email address?

Re: Email hyperlinking?

Alexander_Thor — Wed, 20 Jun 2012 22:22:58 GMT

Absolutly,

If you have a button you could use the open url action with the following expression:
='mailto:' & [Email address]

This would work for urls in tables aswell.

If you run your apps from the phone you could even dial from QV, ='tel:' & [Telephone Number]

Or if you have voip software like skype use callto:// links

Re: Email hyperlinking?

Thu, 21 Jun 2012 13:12:42 GMT

Thanks for the help Alexander!

The only trouble I'm experiencing in this is that although a new email draft opens, it doesn't auto-fill the sender name in the actual email. For example, if I were to input the expression ='mailto:' & [Josh@qlik.com], it would only open an email with no inclusion of sending the email to Josh@qlik.com. Any idea if this is possible?

Re: Email hyperlinking?

Alexander_Thor — Tue, 26 Jun 2012 11:28:53 GMT

That is strange. I just tested this expression and it works fine over here

='mailto:' & 'alexander.karlsson@qlik.com' & '&subject=This is the subject'

Tested both in desktop and deployed onto QlikView Server and accessed via ajax-client.

Running QV11 SR1 and Outlook 2007.

Re: Email hyperlinking?

Anonymous — Tue, 15 Jul 2014 02:40:51 GMT

Hi Alexander

That was very helpful but do you know of anyway to use a field/variable in the subject?

Thanks

Bella

Re: Email hyperlinking?

engishfaque — Tue, 15 Jul 2014 04:49:32 GMT

Dear Joshberne,

Solved problem, Kindly find attached screen shot for sending email To, CC, BCC with Subject and Date.

Please mark Correct Answer, as the discussion can be closed.

Kind regards,

Ishfaque Ahmed

Re: Email hyperlinking?

engishfaque — Tue, 15 Jul 2014 05:16:20 GMT

Dear Joshberne,

Sender email is automatically displayed at the reciever side. As it is showed in attached screen shot.

Kind regards,

Ishfaque Ahmed

Re: Email hyperlinking?

Anonymous — Tue, 15 Jul 2014 21:53:20 GMT

Thank you Ishfaque that was very helpful

Re: Email hyperlinking?

pradnyat — Tue, 16 Sep 2014 09:19:08 GMT

Hi,

Can we attach some sheet image as attachment in the same email.

Thanks in Advance.. !

Re: Email hyperlinking?

deepti_singh — Fri, 20 Mar 2015 18:01:30 GMT

Hi Ishfaque,

I have the same requirement. I need to export a report in an email. But I have few questions first, which may sound silly but please play along. When a button is created with the action "open in url", does it import just import one object or the whole report or the selections that we made?

I created a button with the expression ='mailto:' & email-address'. But I get the below error when I click on the button.

1. What type of Ajax settings do I need?

2. Also in what format is the report sent out? html or any other format?

Thanks.

Regards,

Deepti

Re: Email hyperlinking?

marcus_sommer — Sat, 21 Mar 2015 11:21:04 GMT

I think attachments aren't possible in this way: Mailto with attachment - Unity Answers. But you could create a link within the mail-body to these files like:

mailto: someone@anywhere.com?subject=FileLink&body=file://\\YourServer\YourFolder\YourFile.html

- Marcus

Re: Email hyperlinking?

Anonymous — Thu, 22 Sep 2016 15:34:11 GMT

Hi Alexander,

Can you please send me the expression for an email that can be used in table. Please advise.