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:
Post a Comment