Multiple email adresses in table, open at one click

[maiqqi]

Hello

I have case that i have multiple rows with company name, contact person, and e-mail link (mailto://xx@xx.com))

I need button or some other solution to get all email-adresses at the table to open in outlook at one click.

I was thinking that text string, which starts with "mailto://aa@aa.com;bb@bb.com...." would work, but I did not had enough skills to do that.

[v-sihou-msft]

@maiqqi

We can use CONCATENATEX() function to get the string like "mailto:xx@xx.com; yy@yy.com". However, as I tested, currently the mailto link type can only support single mail address, it doesn't work for multiple addresses.

It returns nothing when clicking on concatenated string.

I suggest you leave your comments on this idea.

Regards,

[maiqqi]

Thank you for your reply!

It work for me with this string:

Power BIPower BIOutlookExcel

I think i need just create that string like "mailto://:xx@xx.com; yy@yy.com; xx@xx.com"

[v-sihou-msft]

@maiqqi

To get that string, you can create a calculated column like:

mailtoall = "mailto://"&CONCATENATEX(ALL(Table1),Table1[Column1],"; ")

Regards,

[maiqqi]

It worked very well, but now i have new problem.

I'm using slicer to categorizate companys, becouse I have like 300 companies on that list. Now if i choose one category, mailtoall-link create link to all contacts, not that specified category. Is there any solution to avoid that?

[v-sihou-msft]

@maiqqi

That could be a problem. If you need your concatenation based on selection from slicer, you have to use slicer. However, we can't set "Web URL" data category for a measure so that it's not possible to click.

Regards,

[maiqqi · Accepted solution]

I think i need to make tables that each one include one slicer's catecory to resolve the problem. Other solutioin might be to make string in excel to each kategory.

[maiqqi]

Thank you, I try it!