Automatic Email from Excel after sorting data

Hi All..
I am new to this forum. I need help related to my excel sheet designed to remind my marketing team on their scheduled reminders that have not been updated till TODAY. I want that this code runs once a day and send email seperately to all marketing teams for the customers being dealt by them whose followup needs to be updated. For example if I have two marketing boys Vishal & ishant then Vishal gets email for the customers that are dealt by him and whose followup date is either on or before today. Similary the other marketing guy also gets email. Preferably if the mail can contain subject as " Vishal Followups for 01.12.14"

I am not knowledgable regarding coding but can handle stuff at my computer otherwise. I am attaching a copy of excel file for better understanding. Thanks a lot guys in advance.


BTW my default mail client is Outlook.

regards,

panx.

hi humdingaling..
yes it looks similar but there are a few differences from my file:
1. my cells will have repetitive names of marketing boys, as per customers being handled by them.
2. I want to email all rows of say Ishant to his email address on the basis of reminder dates equal to TODAY Or Earlier than today. So basiclly it will have a consolidated list in one email for all customers handled by Ishant whose followup date is today OR earlier than today.
3. and yes similar to the other file of yours i want the file to run automatically on system startup with Subject as " Ishant your followups due for <Todays Date> "

can you please help me with the code for the above.

Thanks a ton..