how to send each row by email

[Excel Fox]

So in your attachment, you can check column N like this

If Range("N" & lngRow).Value < 5 Then
'your code to send the message
'in the To part, use Range("C" & lngRow).Value
Else
'Do Nothing
End if

You'll have to make the adjustments..... if it's not clear, post back with a sample of the excel saved attachments