I have a spreadsheet with data that looks something like the data below. I
am looking for a way to automate sending an email to each user (Email Field)
with all the rows that include data for that User

Date Email Subject
6/27/2005 Test4
6/27/2005 Test7
6/28/2005 Test3
6/28/2005 Test6
6/29/2005 Test1
6/29/2005 Test2
6/29/2005 Test5

For would get an email with the following
information

Date Email Subject
6/29/2005 Test1
6/29/2005 Test2
6/28/2005 Test3
6/27/2005 Test4

Any ideas on whether Excel can even do this....and if so, how one would go
about making it happen.

Thank you