Knowledge Base Article

Hyperlink To Email - Gmail, Yahoo, And Outlook

Sisense has a lot of cool functionality around converting links to a simpler format using Markdown language. However, doing things that require more advanced functionality such as bringing up an email takes a little more maneuvering. Luckily, the internet can be a kind place with logic from time to time. From this post:

Gmail:
select
  '[' || table.email ||'](https://mail.google.com/mail/?view=cm&fs=1&to=' || replace(table.email,'+'
,'%2B') || '&su=&body=)'
Yahoo:
select  '[' || table.email || '](http://compose.mail.yahoo.com/?to=' || replace(table.email, '+', '%2B') || '&subj=SUBJECT&body=BODY' || ')'
Outlook:
select  '[' || table.email || '](https://outlook.live.com/owa/#subject=SUBJECT&body=BODY&to=' || replace(table.email, '+', '%2B') || '&path=%2fmail%2faction%2fcompose' || ')'
Note: for plus signs, use %2B to replace any + in your email address!
Updated 03-02-2023
No CommentsBe the first to comment