Email from Excel to notify expiry date using Lotus Notes

First, hello all, i this my first post in this forum, im in desperate need of HELP...!

I been fiddling with the idea to notifying some of my users of the expiration date of their accounts, that i have in a excel spreadsheet.

Every thing works good, ecxept for on small detail. The main function that validates the date, takes reference from the current date + 7 so it gives a week's notice to the end users, and it does send the email, but, it only send it to the first user that meets the condition requirements. The rest of the listed users are not validated, hence the are not notified, even if they meet the date conditions.

I have used as referenece the following:
http://www.excelforum.com/excel-prog...piry-date.html
http://www.mrexcel.com/forum/showthread.php?t=139949
http://www.bygsoftware.com/Excel/VBA...otus_notes.htm

I just whant to mention that this is the firt time i use VB for macros and it has taken me 3 days to get where i am right now. Please see attached file so you can better understand the sitiuation.

In advaced thank you for your help.

Best Regards.