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.

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