Multiple Emails to same recipient

Hi,

I wrote a VBA Code to send a mail to the recipient based on a criterion. My next step is a bit complex and I am not sure how to proceed.

Problem:

I have a criterion, passing which, a mail will be sent to a recipient. But there shall be several instances where the criterion is TRUE and more than one mail will be sent to the same person. In the actual application, a person could receive upto 10 mails with a slight modification in the email body. I would like to group the information to be written in the email body and send it to the recipient as one mail. Please have a look at the file here. Based on the code, the criterion is if the value in H:H is <= -2, the programmed Actions will be performed. Assuming that the criterion is TRUE and more than one set of detail have to be sent to the same Person (based on Email in E:E), I would like to send it as one mail.

Ideas:

inserting an additional criterion after the first set of FOR and IF Statement and the new criterion is to check if there are more than one instance of the email recipient. If the condition is TRUE, insert a FOR Statement to gather data from all the possible mails to be sent to each recipient.

I am still learning VBA and not sure how to proceed with this idea. Any suggestions or sample Code is highly appreciated. Meanwhile, I will try to solve the query myself.

Thank you!

Regards,
Bharath

Please Login or Register  to view this content.

Hi, sorry, I forgot to create the Hyperlink. You can find it with this link. (Forum restricted me from creating Hyperlink)

//drive.google.com/file/d/1lrUL_Ng5szvjKiR5dDYpHqVHDckge7Uc/view?usp=sharing

("https:")