Collecting Completed Forms

[Mel]

First the good new: Everyone in my company has InfoPath 2003 installed on
their computer!

The problem is that we are not on a common network so I cannot publish forms
to a shared folder. I also do not have access to SharePoint or a Web Server.
I would like for employees to be able to e-mail the forms to me and I would
collect the data on my end in an Access database. I found plenty of
information on creating a form from the database and e-mailing forms but
nothing about collecting information once the forms have gone out. Is this
possible?

 

[Badajoz95]

To get the completed information back... get them to use the File \ Send to
Mail Recipient option. Or programmatically give them a button that performs
this command.

To merge the data (which is XML btw) into an Access Database:

(1) Use the Import Table option within Access. This will do 1 file at a time
so you will need to bunch them together to do all of them (manually edit and
add them together). When you bunch them together you need to remove the last
XML line from the first one and the first XML line from the next one...
basically making them 1 big XML repeated definition.

(2) Bunch them all together using XSLT, .NET, BizTalk, SQL Server (OPENXML
command with DTS) or any other tool / technology to aggregrate the XML
together.

I am not aware of any tool that already provided in Office 2003 that is
capable of aggregating the XML information without this effort.

 

[Badajoz95]

Or use the Sharepoint User Interface: create the library, then set the
template (thanks Patrick Halstead)

 

[Badajoz95]

Oops - ignore that last - post it was for a different thread... sorry