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 [email protected] Test4
6/27/2005 [email protected] Test7
6/28/2005 [email protected] Test3
6/28/2005 [email protected] Test6
6/29/2005 [email protected] Test1
6/29/2005 [email protected] Test2
6/29/2005 [email protected] Test5

For [email protected] would get an email with the following
information

Date Email Subject
6/29/2005 [email protected] Test1
6/29/2005 [email protected] Test2
6/28/2005 [email protected] Test3
6/27/2005 [email protected] Test4

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

Thank you