Friday, March 9, 2007

Collecting data with Microsoft Office Access 2007 and InfoPath 2007

Did you know that you can use Microsoft Access to generate InfoPath forms which can be used with Outlook to gather data from people and automatically collate the responses to the email back into Access?

From the Access Help;

Microsoft Office Access 2007 makes it easy to gather data from people who are located anywhere on the globe, such as members of your sales team, survey participants, or contacts. Office Access 2007 works with Microsoft Office Outlook 2007 to help you to generate and send an e-mail message that includes a data entry form. When the recipients fill out the forms and send them back to you, the replies are processed according to your specifications. For example, if you choose to have the replies automatically processed, the contents of the form are added to the appropriate table in your database as soon as the reply reaches your inbox. This new feature, the Collect data through e-mail messages Wizard, can save you hours that you might have otherwise spent entering data on behalf of your users.

Check out this blog entry by Balamurali Balaji;

http://www.codeproject.com/useritems/integration.asp

No comments: