Reference every cell in column in an email subject line

[timlh42]

I have a list of names, last name in column A and first name in column B and a date in column C. When the date in column C is a year old my macro copies the name from A and B in the same row to cells I and J.

It then looks for any names in I and J and sends an email out to remind me that the person is in need of their yearly review. That works great but if I have more than one name in columns I and J, I would like the email to include all of them.

Here is a snippet of what I have so far:

.Subject = "Review needed for" & " " & Range("I2").Value & " " & Range("J2").Value


Any help would be greatly appreciated!!

 

[crazydragon84]

you want the subject to contain names of everyone in columns I & J or you want to loop through everyone in I & J and have a separate e-mail for each one?

 

[timlh42]

I just want the subject to contain names of everyone in columns I & J