Forum Discussion

yosemite's avatar
yosemite
Helper III
6 years ago
Solved

Bulk email/mail: multiple emails

Hi, guys These ideas were presented several years ago. Do you know if it is now possible to send a group email to the users listed in my table? https://ideas.powerbi.com/forums/265200-power-b...
  • pdbenbow's avatar
    pdbenbow
    6 years ago

    yosemite , thanks for linking to my solution from last year. I uploaded your PBIX file to the Power BI Service without making any changes, and your "Email All" button worked well. The measure you created is correct. I think the limitation you're seeing is just related to Power BI Desktop.

yosemite's avatar
yosemite
Helper III
6 years ago

Hello Anonymous ,

 

This formula for single email works to open the mail application:

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

 

But this formula for multiple email doesn't open the mail application even if it is categorized as a Web URL in Power BI desktop:

Email All = "mailto:" & CONCATENATEX(VALUES ('Table'[Email]), 'Table'[Email], "; ")

 

Do you mind updating the PBIX I posted to show how you made it work? Thanks for your help.

pdbenbow's avatar
pdbenbow
Resolver II
6 years ago

yosemite , thanks for linking to my solution from last year. I uploaded your PBIX file to the Power BI Service without making any changes, and your "Email All" button worked well. The measure you created is correct. I think the limitation you're seeing is just related to Power BI Desktop.

  • hokeson's avatar
    hokeson
    Microsoft Employee
    1 year ago

    it works also in desktop.

    just use following DAX

    Email All = "mailto:?to=" & CONCATENATEX(VALUES ('Table'[Email]), 'Table'[Email], "; ")
  • yosemite's avatar
    yosemite
    Helper III
    6 years ago

    pdbenbow You are right. Thank you so much!