How to send a message to two batches of Email List - REframework

[Sisay_Dinku (Sisay YDG)]

Hi team,

I’ve an RPA process in production that sends a message to multiple recipients (email addresses) at once. The shared mailbox that used to send the email out has the permission to send to a maximum of 1000 recipients per message. Now the list is growing greater than 1000 and causing a problem (failing to send). So, I have planned to split the list of mails into two batches (first batch and second batch).

I am using DataRow as a transaction item in Reframework. I want my process to send email two times (first the first batch email, second the second batch email), meaning two transactions. I am stuck here and not sure what should be the next step. Do I have to create another data table that considers DT_FirstBatch and DT_SecondBatch as first and second row?

Can anyone give me an insight?

Thanks a lot for your time.

Sisay

[lrtetala (Lakshman Reddy)]

Hi @Sisay_Dinku

Can you try the below code

After you get the datatable the below code splits the data to your requirement then send mail

1.DT_Emails=DT.DefaultView.ToTable(False,"Email Address")   'Replace your column name
2.List_EmailsDT=DT_Emails.AsEnumerable.Chunk(2).Select(Function(a) a.copytodatatable).tolist    'Replace **2**  with your required rows i.e.,1000

BlankProcess16.zip (6.4 MB)

Cheers!!

[Sisay_Dinku (Sisay YDG)]

Hi @lrtetala

Thank you for taking the time to look into this.
I’ve a couple of follow up questions with your suggestion.

1. I see the following error in the values of list of data table expression (DT_Emails.AsEnumerable.Chunk(3).Select(Function(a) a.copytodatatable).tolist)
   Here is the error: ‘Chunk’ is not a member of ‘System.Data.Enumerable Row collection (of System.data.DataRow)’

• In the above expression what does ‘Chunk(3)’ entails?

2. When using Reframework and DataRow transaction items, which data table am I going to use for the process two send row by row (two transactions) for the two email batches?

Please let me know if you’d need more information.

Thanks!

[ppr (Peter Preuss)]

@Sisay_Dinku

‘Chunk’ is not a member of ‘System.Data.Enumerable Row collection (of System.data.DataRow)

Available when Project is set to Windows Compatibility

When Project is set to Legacy Compatibility we can work with skip/take

Process repeated for each multiple rows

@christine.tzenghy let me introduce a general approach that can be also adopted to more case specific details. Assumptons: DataTable with 8 Rows Segmentsize: 3 Following Building Blocks are used Calculation of the numbers of segments: [grafik] with the Ceiling method the fractions are uprounded to the next Integer with the Skip() and Take() Method the Rows for a segment can be retrieved. the different segments are bult by following [grafik] and do fetch the different segment rows by: …

Split the output data table into smaller data table which contain 50 rows per data table

can be done with skip take: in the combination with copytodatatable split results are datatables: In Additiona to above find a compacted variation: Assign Activity: SegmentSize | Int32 = 50 Assign Activity: NoOfSegments | Int32 = Convert.ToInt32(Math.Ceiling(dtData.Rows.Count / SegmentSize)) Assign Activity: TableList | List(Of DataTable) = Enumerable.Range(0,NoOfSegments).Select(Function (x) dtData.AsEnumerable.Skip(x*SegmentSize).Take(SegmentSize).CopyToDataTable).ToList() For each…

For learnings also have a look here:

[HowTo] LINQ - First Start # Skip | Take | SkipWhile | TakeWhile Operator

This HowTo gives an introductory overview of the partition Operators: Skip, Take, SkipWhile, TakeWhile Introduction The partition operators are used to fetch a particular subset from a set of items. The returned subset is formed by the contiguous items that are matching the provided condition. Skip / Take Operator The Skip Operator will omit the subsequent items from the given start for a given length and will return the remaining items The Take Operator will return the subsequent items fr…

[Sisay_Dinku (Sisay YDG)]

Hi @ppr
Thank you for clarifying that the issue is compatibility related. Also, appreciate for sharing the articles. Got it!
I’ll come to next question but for now let me ask this,
How do you re-write the above expression (DT_Emails.AsEnumerable.Chunk(3).Select(Function(a) a.copytodatatable).tolist) using Skip/Take. I am a little bit confused.

Thank you!

[Sisay_Dinku (Sisay YDG)]

@ppr

Just an update: I was able to write expression for Table list for skip/take scanario.
(Enumerable.Range(0, NoOfSegments).Select(Function(x)DT_Emails.AsEnumerable.Skip(x * SegmentSize).Take(SegmentSize).CopyToDataTable).ToList())
Now my next question: How can I send the message for two email batches in Reframework? I want to envision, how that portion works.

Thanks!

[Sisay_Dinku (Sisay YDG)]

Hi @ppr @lrtetala

Following up with the second question on the third post…

@Sisay_Dinku

When using Reframework and DataRow transaction items, which data table am I going to use for the process two send row by row (two transactions) for the two email batches?

[Sisay_Dinku (Sisay YDG)]

Hi team,
Can anyone look into this and give me insight?
@ppr @lrtetala @Yoichi

Thank you.

[Sisay_Dinku (Sisay YDG)]

Hi Team

I followed the above steps and added back to another Data Table, and from there, we can use REframework with the transaction item being DataRow.

Thank you all for the effort.