Monday, December 22, 2008

Better way to get informations like Survey, Feedback, Status Report

Requesting information through Email?

Tired of Consolidating the email response received with information from the mail recipients?InfoPath and Outlook 2007 there to rescue. Move all the response to a folder
and click on export to excel button in outlook 2007 to get all the
information with response from all the respondents in a excel file.

Design an InfoPath form by just dragging and dropping controls into the form.


Go to Tools Form Options Security and Trust Tab

Enable full Trust and check on Sign this form Template. If the name doesn’t appear click on create certificate.


Select File Publish and select To a list of e-mail recipients.



Add the Columns that is required to be displayed in the outlook view



Enter the list of recipients in the To list and/or CC list



Create a new folder in Outlook with folder content type as InfoPath form Items as shown in
the screen shot below



Move all the response mails to the newly created folder. You can even write a rule to
automatically move mail responses to the folder created, Click on export to excel button in Outlook 2007







Get the consolidated information in the excel file without even opening the mail responses.



No comments: