Send an email with a dynamic range of cells that differ depending on the date

Hi all,

I have a large file that contains approximately 7k lines, with one different equipment on each row. All of these equipments have End of Service dates, and therefore can be identifiable through not only their names, but by when they will be unusable.

I wanted to create a macro that would send an email to the recipient (email address) written in column S if the date of EOS of the equipment is within the next 30 days. Now I have been struck with the idea of optimizing my existing program by sending all equipments with the same EOS date in ONE single email, instead of sending multiple mails, each with one equipment per body. However, I have not been very successful at doing so, and despite having browsed every single possible thread there is on a dynamic range insertion to the body of an email, I have yet to find out how I can achieve that.

I have ideas on how it could be done but I do not know whether it is virtually possible or not. I thought maybe I would have to add all of the elements that would come out from my first if statement to an array, and then dump that array in the body of an email, but that didnt work. I also tried the "HTMLtorng way", but I do not like the format of the email. I simply want to do a "Paste Values" of the content of multiple cells that have an end date within the next 30 days.

Thank you in advance for any help,
Clement

Thanks for the help bakerman, I'll try to do that and come back to you later!