Macro to send an email of specific rows

Hi Humac

OK...so in your sample file the Email address is NOT in column P "Email ID". Is this the case in the "real world" or in the "real world" will the "Email ID" be in column P?

Or do we need

we have a email in the separate sheet with the emails defined in it

I'm asking this because I need to know from where to pull the Email address. If they're in column P and they're the same for the group it's rather simple. If they're not in column P but in a different worksheet...not as simple but not complicated. Just need to know where the email addresses live.

We can do this

If it can club the similar groups into single mail and send it that would be great