# Sending multiple rows in one email

**URL:** <https://community.parabola.io/t/sending-multiple-rows-in-one-email/2130>\
**Category:** Ask a question\
**Created:** [November 14, 2021, 3:55pm UTC](https://community.parabola.io/t/sending-multiple-rows-in-one-email/2130 "2021-11-14T15:55:03Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Annika\_Cederblad](https://avatars.discourse-cdn.com/v4/letter/a/a88e57/32.png) [@Annika\_Cederblad](https://community.parabola.io/u/Annika_Cederblad)\
**Post date:** [November 14, 2021, 3:55pm UTC](https://community.parabola.io/t/sending-multiple-rows-in-one-email/2130/1 "2021-11-14T15:55:03Z")

</div>

Is there a good way to send multiple rows in one email, grouped on a field? For example if my data is:

Vendor // Quantity // Item  
[vendora@gmail.com](mailto:vendora@gmail.com) // 2 // Apple  
[vendora@gmail.com](mailto:vendora@gmail.com) // 7 // Pear  
[vendorb@gmail.com](mailto:vendorb@gmail.com) // 10 // Kiwi

I would want to group the information sent based on the vendor field; Vendor a would receive 1 email with 2 fields and vendor b would receive 1 email with 1 field.

Ideally would love to send a CSV file with the information filtered by a field but if there is a way to do it in a semi-formatted way in just an email that would work too.

---

<div class="post-metadata">

**Author:** ![eddie](https://sea2.discourse-cdn.com/flex020/user_avatar/community.parabola.io/eddie/32/1707_2.png) [@eddie](https://community.parabola.io/u/eddie)\
**Post date:** [November 15, 2021, 1:52am UTC](https://community.parabola.io/t/sending-multiple-rows-in-one-email/2130/2 "2021-11-15T01:52:30Z")

</div>

Hi @Annika_Cederblad,

If I’m understanding you correctly, you’d like one email to go to Vendor A that reads…

> 2 Apple  
> 7 Pear

And a second email to go to Vendor B that reads…

> 10 Kiwi

One way to do that would be to use an insert [text column step](https://parabola.io/transform/insert-text-column) in order to create a new column that combines the Quantity text and the Item text into one sentence. For this example, I named the new column “Email copy”.

 ![Screen Shot 2021-11-14 at 8.33.12 PM](https://us1.discourse-cdn.com/flex020/uploads/parabola/original/2X/1/13eb457059a335284c25d61a719dd7a6fdd92795.png)

Then you could add a [merge duplicate rows](https://parabola.io/transform/merge-duplicate-rows) step that merges the value of multiple Email copy fields into just one row per vendor.

 ![Screen Shot 2021-11-14 at 8.33.01 PM](https://us1.discourse-cdn.com/flex020/uploads/parabola/original/2X/b/b3d5d0219364bf60ecc7eb19e37f82375551a52f.png)

I used two html line breaks for the delimiter so that each of your Email copy sentences will appear on their own lines in the outgoing emails.

You’ll want to be sure to set your outgoing emails to HTML for the line breaks to work properly.