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 guys,

 

These ideas were submitted several years back. 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-bi-ideas/suggestions/19156099-mass-email

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/20288017-mailto-multi-recipients

 

It looks like the mailto link is still currently designed to send an email to single recipient. Let me know if I'm wrong.

 

https://bimentalist.com/2018/06/27/how-to-create-email-link-in-your-power-bi-dashboard/

 

Thanks you.

  • parry2k's avatar
    parry2k
    Super User
    6 years ago

    yosemite looks like a duplicate post.

    • paulinka's avatar
      paulinka
      New Member
      3 years ago

      Your database should contain a column with the following inputs :

      mailto:mike@[email protected] - an e-mail will be sent to both Mike and John (**Example below)

      mailto:mike@[email protected] - by exchanging "?to=" with "?cc=", an e-mail will be sent to Mike with John on copy

       

      **Example of a database in Excel:

      Create a column "Count" to count owners listed by "/"

      Cell C2 =IF(LEN(TRIM(A2))=0,0,LEN(A2)-LEN(SUBSTITUTE(A2,"/",""))+1)

      Create a column "mailto to" using diverse functions (this function is limited to 2 owners). I setup a fixed range of data $A$2:$B$5

       

      Cell D2 =IF(C2=2,"mailto:"&XLOOKUP(IFERROR(LEFT(A2,FIND("/",A2)-1),A2),$A$2:$A$5,$B$2:$B$5,"")&"?to= "&XLOOKUP(IFERROR(RIGHT(A2,LEN(A2)-FIND("/",A2)), A2),$A$2:$A$5,$B$2:$B$5,""),CONCATENATE("mailto:",B2))

       

      In PowerBI, change the column category to Web URL and activte visual (VISUAL --> URL icon --> ON