Sending email to multiple CC's

Is there a way to use the Create & send a Message through the Microsoft 365 Email app so the email will be sent to multiple CC’s in one time?

Is there a way to put in the To recipients multiple email addresses?

Or is there other ways to send this email to multiple recipients at once (at the same thread)?
‏‏לכידה

Hi @Ido_Puterkovski
Yes, you can add CC address as follows:

You can add multiple recipients by simply clicking on “Add Item,” as shown:

If you require additional assistance, please don’t hesitate to reach out to us.
MSquare Support
Visit us here
Youtube Channel

2 Likes

According to the sendMail endpoint on the Microsoft 365 Mail Documentation, toRecipients field accepts an array of collections, each looks like this:

{
  "emailAddress": {
    "address": "frannis@contoso.com"
  }
}

So you’ll need to build the array using an aggregator, so your final structure of the array variable will look like this:

"toRecipients": [
  {
    "emailAddress": {
      "address": "frannis1@contoso.com"
    }
  },
  {
    "emailAddress": {
      "address": "frannis2@contoso.com"
    }
  },
  {
    "emailAddress": {
      "address": "frannis3@contoso.com"
    }
  }
]

Every result (item/record) from a search/match module will output a bundle. To “combine” them into a single structure, you’ll need to use an aggregator of some sort.

Aggregators are modules that accumulate multiple bundles into one single bundle. An example of a commonly-used aggregator module is the Array aggregator module. The next popular aggregator is the Text Aggregator which is very flexible and has applies to many use-cases.

There are other types of aggregator modules, click the below links to find out more:

Read this

The Array Aggregator module allows you to build a complex array of collections for a later module’s field to map multiple items (collections) to it.

Here is an example of using the “Target structure type” of an Array Aggregator module:

As you can see, the “Map” toggle on fields are used when you have an array. You can easily build an array variable to map to a field, by using an Array Aggregator module and select the “Target Structure Type” as the future field you want to map the array into.

samliewrequest private consultation

2 Likes

Hey @samliew thanks again for the fast helping!

I used the aggregator app and even have got all the emails adresses and the recipients name in on bundel but than, when I filled the Create & send a Message module with those values (As you can see in the pictures it sended the email just to the first recipient.

Do you have an idea what could be the reason?


‏‏לכידה.JPG1

Thanks again @samliew for your kind and fast help!

I have tried using the array aggregator and even manage to aggregate all the email

addresses and the recipients names to one array (attached image) but as I put the values in the Create & send a Message modules (under the To area, as you can see in the image I have attached) it sended the email just to the first address (from the first collection within the array).

Do you have an idea what could be the reason?


‏‏לכידה.JPG1

Thanks @Msquare_Automation !

The thing is that I need to fill the email addresses and names as arrary because I don’t know how many addresses I have in each team).

f7618eb75933c25b11e295636c83583de51d39ca

Map (Insert) the whole array into the “To Recipients” field, not the “Email Address” or “Name”.

3 Likes

That works! Thanks again, you are just amazing @samliew

2 Likes

No problem, I’m really glad I could help!

1. If you have a new question in the future, please start a new thread. This makes it easier for others with the same problem to search for the answers to specific questions, and you are more likely to receive help since newer questions are monitored closely.

2. The Make Community guidelines encourages users to try to mark helpful replies as solutions to help keep the Community organized.

This marks the topic as solved, so that:

  • others can save time when catching up with the latest activity here, and
  • allows others to quickly jump to the solution if they come across the same problem

To do this, simply click the checkbox at the bottom of the post that answers your question:
Screenshot_2023-10-04_161049

3. Don’t forget to like and bookmark this topic so you can get back to it easily in future!

samliewrequest private consultation

Join the Make unofficial Discord server!

1 Like