Unanswered

Send email Bcc from collection , how to send a 2nd email if list is over 500 emails limit

(0) Share

Report

Posted on by JD_26

102

I have created a bulk email feature , but from reading other comments I believe MS Outlook limits the Bcc list of emails to 500 per email.

My question is , is there a way in PowerApps that if the collection has more than 500 emails and <= 1000 emails , then split the

send email into 2 emails. So the first email sends bcc contacts 1 to 500 from the collection and then another email is sent with >501

My current code is

Clear(bulk_mail_full);
ForAll(mass_contacts_gallery.AllItems,Collect(bulk_mail_full,{AccountID:field_12,code:field_2,email:field_4,account:field_1,region:Region,country:Country,Dataset:Dataset,DatasetSubtype:'Dataset Subtype',SMRep:field_10,ActivityComment:field_4 &" sent " & activity_message.Text}));
ForAll(bulk_mail_full,Patch(Activity_List,Defaults(Activity_List),{AccountID:AccountID},{Title:code},{field_1:account},{field_2:DatasetSubtype},{field_4:SMRep},{field_5:Today(),field_7:ActivityComment}));
Office365Outlook.SendEmail(
"supplierrelations@email.com", // add SupplierRelations@email.com
email_subject.Text,
"<img src=" & header &">" & "</img>" & email_message.HtmlText &
"<a href="&"https://www.youtube.com/watch?v=_" & "class="&"class"&"> <img src="& footer &"> </a>" ,
{
Bcc: Concat(bulk_mail_full,email,";"),
Importance: "Normal",
IsHtml: true
}
);
Set(var_send_mail,false)

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

timl 36,383 Super User 2025 Season 2 on at

Like (0)

Report
Hi @JD_26

If you can be sure that there will not be more than 1000 recipients, you could do this with the following 'If' syntax.

If(CountRows(bulk_mail_full) > 500, //Send first 500 Office365Outlook.SendEmail( "supplierrelations@email.com", // add SupplierRelations@email.com email_subject.Text, "<img src=" & header &">" & "</img>" & email_message.HtmlText & "<a href="&"https://www.youtube.com/watch?v=_" & "class="&"class"&"> <img src="& footer &"> </a>" , { Bcc: Concat(FirstN(bulk_mail_full,500),email,";"), Importance: "Normal", IsHtml: true } ); //Send remaining records Office365Outlook.SendEmail( "supplierrelations@email.com", // add SupplierRelations@email.com email_subject.Text, "<img src=" & header &">" & "</img>" & email_message.HtmlText & "<a href="&"https://www.youtube.com/watch?v=_" & "class="&"class"&"> <img src="& footer &"> </a>" , { Bcc: Concat(LastN(bulk_mail_full,CountRows(bulk_mail_full)-500),email,";"), Importance: "Normal", IsHtml: true } ) , Office365Outlook.SendEmail( "supplierrelations@email.com", // add SupplierRelations@email.com email_subject.Text, "<img src=" & header &">" & "</img>" & email_message.HtmlText & "<a href="&"https://www.youtube.com/watch?v=_" & "class="&"class"&"> <img src="& footer &"> </a>" , { Bcc: Concat(bulk_mail_full,email,";"), Importance: "Normal", IsHtml: true } ) )

Was this reply helpful? Yes No
JD_26 102 on at

Like (0)

Report
Thanks for providing this solution , yes I can set the send email button to be only visible if less than or equal to 1000

Quick question , before I test it out , does the -500 mean it removes the first 500 in this code
Bcc: Concat(LastN(bulk_mail_full,CountRows(bulk_mail_full)-500),email,";")

Was this reply helpful? Yes No
JD_26 102 on at

Like (0)

Report

Is there a way to add a count of how many emails are in email 1 and email 2 , please
I tried to create a formula but was struggling to get it to work
"Total selected contacts email " & CountIf(CountRows(bulk_mail_full) > 500)

Was this reply helpful? Yes No
timl 36,383 Super User 2025 Season 2 on at

Like (0)

Report
Hi @JD_26

With regards to the beneath, yes that's correct.

>> Quick question , before I test it out , does the -500 mean it removes the first 500 in this code

Bcc: Concat(LastN(bulk_mail_full,CountRows(bulk_mail_full)-500),email,";")

In terms of your second question, a count of the number of records in bulk_mail_full will give you the combined number of recipients in both email 1 and email 2.

"Total selected contacts email " & CountRows(bulk_mail_full)

Was this reply helpful? Yes No
JD_26 102 on at

Like (0)

Report
Thanks I was already using this , but wanted to be able to provide a count for each email , so if 620 email were selected , then I wanted the formula for email 2 to be showing 120
"Total selected contacts email 2 " & CountRows(bulk_mail_full)

Was this reply helpful? Yes No