# Send an Email to multiple Email Ids in an Excel file

**URL:** https://community.automationedge.com/t/send-an-email-to-multiple-email-ids-in-an-excel-file/11158
**Category:** Get Help & Discuss
**Tags:** generic, rpa
**Created:** [November 6, 2023, 7:26am UTC](https://community.automationedge.com/t/send-an-email-to-multiple-email-ids-in-an-excel-file/11158 "2023-11-06T07:26:23Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![Hannah\_Meyer](https://avatars.discourse-cdn.com/v4/letter/h/58956e/32.png) [@Hannah\_Meyer](https://community.automationedge.com/u/Hannah_Meyer)
#### Post date: [November 6, 2023, 7:26am UTC](https://community.automationedge.com/t/send-an-email-to-multiple-email-ids-in-an-excel-file/11158/1 "2023-11-06T07:26:23Z")

</div>

Hi! All

I have a list of email ids in a column in an excel file. I wish to send an email to all the email ids. Please suggest how to design an AutomationEdge workflow for this?

---

<div class="post-metadata">

### Author: ![Anjaliks](https://avatars.discourse-cdn.com/v4/letter/a/5f8ce5/32.png) [@Anjaliks](https://community.automationedge.com/u/Anjaliks)
#### Post date: [November 6, 2023, 7:32am UTC](https://community.automationedge.com/t/send-an-email-to-multiple-email-ids-in-an-excel-file/11158/2 "2023-11-06T07:32:03Z")

</div>

Hi!

The following image shows a sample workflow. It reads the emails column from an excel sheet. The image also shows the Group By step configuration. Use the Group Type as - Concatenate strings separated by and in the Value field provide a semi-colon(;). Now you can use this aggregated field containing a semicolon separated list of email addresses in the recipient field of the O365: Send Email step.

 ![image](https://canada1.discourse-cdn.com/flex027/uploads/automationedge/original/2X/0/0cc664dc629cb0b9379321cd857e4b79977e5d3d.png)
