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:

https://stackoverflow.com/questions/6548570/url-to-compose-a-message-in-gmail-with-full-gmail-interface-and-specified-to-b

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

CDT