Compile List of Rows With an Empty Cell
 

Hi all.

I have a spreadsheet with related information in each row. What I need to
do is email a list of items that do not have a completed date entered if it
is past the current date.

I have a function that send an email. I can find the empty cells but what
is the best way to compile the list of rows that i need and then add then to
an email? Can I use an array or a set of arrays? Can I send an email with
that much information using the following:

With OutMail
.To = strTO
.Subject = strSubject
.HTMLBody = strBody
.Send
End With