InfoPath Dev

Hello Everyone, I need outlook to automatically populate an infopath form. Ex. 1. Email is received in outlook. Outlook checks subject and sender and if meets certain conditions, the email in sent to a SharePoint library where an infopath form is stored.  and automatically updates the form.   Can this be done.  Any help will ...

 I have a repeating table that is filter by dates. The user chooses what dates the repeating table will show and hide the other rows that are outside of the dates selected. the rows have a field that is a drop down selection that can be YES or NO.  I need to count that field for all instances of YES  that are within the dates ...

 Thank you for the help, I was able to edit the form.  Someone else posted about 2003 not I.

 Sorry to keep bothering you on this, but I have infopath designer 2010 and I can open it but no edit it.

 The form is what i am looking for. Can you sent in a template form. I was not able to edit the form or see any of the formulas.

I created an attendance tracker that is base on dates. I used a repeating table that has a fields: date, hours worked, hours schedule. I inserted a text box outside the repeating table to add the hours work field. I want to be able to filter that field to add only items within a certain date range. ex( repeating table has date for 5/12/2011, ...