Make email addresses functional mailto links

[gaiusgw]

One of my visualizations includes contact info for customer and I was wondering if it is possible to make the email column into clickable urls that start a new email? 

I have tried using data category to make it url but does not seem to work. 

Anybody have some direction for me?

Thanks a lot. 

[jostnachs]

Is there a way to remove "mail to" and only have the email id as a link?

[PC-BI]

Hi @jostnachs,

The previous response I added to this thread shows email addresses without the mailto... although I didn't post an image of it doing that 🙃

[PC-BI]

Hi @gaiusgw,

I'm sure you've sorted this by now, but in case any one else comes across this post, here's what I did to show working email addresses without the mailto: bit showing:

• Right click on the data source on the right and select New Column
• enter the DAX to concatenate 'mailto:' before the email address: 

Email link = CONCATENATE("mailto:", DataSource[Email])​

• Select the table visual that you are displaying the original (non concatenated) email address in
• Go over to Format your visual
  
• Scroll down to Cell elements and expand it
• Select 'Email' from the dropdown under the Series heading
• Turn on Web URL
• Click the fx button and choose the newly created 'Email link' column under 'What field should we base this on?' heading
• Click OK
• The emails should now show as links and can be clicked on when published

Things to note

• If you have multiple email addresses in a cell at the source, they should be separated by semicolons ;  - your chosen email program may throw an error otherwise
• If the process above hasn't worked, check that both the email and email link columns are set to uncategorised in the data category 

Good luck 🙂

[jostnachs]

I tried this and i still see mailto

[PC-BI]

Hi @jostnachs ,

In the table visual where you are showing the email addresses, are you using the non-concatentated/original email address field from your original data?

You only need to use the concatenated column for the Web URL link bit.

Hope that helps 🙂

[jostnachs]

Hi,

I followed the exact steps given by you. but then i see along with the mail to 😄 dotn know what i missed.

[PC-BI]

Hi @jostnachs ,

Hmm, can you create the table with the normal email address from your data (without the link)? 
 

[V-lianl-msft]

Hi @gaiusgw ,

Please add "mailto:" to the mail address:

Email = CONCATENATE("mailto:",'Table'[Mail])

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[gaiusgw]

Adding mailto: in front of emails in an added column does work but it is not the most elegent solution persay. And any lines that do not have an email will appear as just mailto:. It would be strange if powerbi cannot recognize emails and make them clickable. 

[V-lianl-msft]

Hi @gaiusgw ,

Try work with IF function.

IF(ISBLANK([Mail]),BLANK(),CONCATENATE("mailto:",'Table'[Mail]))

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[gaiusgw]

That did not work. mailto still appeared. Perhaps because those empty cells really have space characters? 

[davehus]

Hi @gaiusgw, There is an element that might need to be turned on in the visualization settings, see below.

[gaiusgw]

Hmm, i do not have that panel as far as I can tell. I am on version 2.91.7 and honestly nervous to update. 

Here is what my panel looks like. 

on another note, if i did update, do you know of any place i can download the version i have now? I have search for archives but cannot fine one.