Good Afternoon,
I am very new to InfoPath but I catch on quick. I have used and created simple InfoPath forms in which the user can access the template, complete the form and then submit the form to a deparment help desk via email. However, it occured to me that InfoPath was capable of much more. I wanted to know if it is possible to create a "issue tracker", of sorts, in InfoPath. I want to design a form where my users (5-6) can access the template on a shared drive, fill it out and send it to multiple "whomevers" :-) (not a static email address). I would then like the information they placed in specific fields to be transmitted to an excel spreadsheet or MS Access table where I can analyze/track the data. Is this possible and how would I go about doing it? I have only seen options that allow for one or the other (email OR xml schema to .xls). Any suggestions? Thank you for any expeditious assistance you can provide.
Employee input > IP form > emailed to Offender(s), Mgrs
>form fields to tracker spreadsheet (.xls) or record in .accdb