Using InfoPath e-mail forms
First I’d like to mention that, as part of a recent announcement, the product name for InfoPath “12” is Microsoft Office InfoPath 2007. This is the name I’ll be using from now on in my blog. In my first post I talk about the benefits of browser-enabled forms. I’d like to focus now on the InfoPath rich client and give you a sense of how it can streamline your daily work with InfoPath e-mail forms. If you are familiar with InfoPath SP1 you probably know that it already allows you to send forms as attachments in email. So why is “e-mail forms” a new feature in Office InfoPath 2007? Well, the limitation in InfoPath SP1 is that forms are just regular attachments and they are not integrated in your Outlook email environment. So in Office 2007 we’ve decided to make forms a first class item in Outlook. That means forms can now be viewed, edited, saved, and forwarded similar to email messages, meetings, or tasks. In addition, e-mail forms can leverage Outlook PIM features like categories and follow up to add a new dimension to your forms workflow. E-mail forms now have their own folder type and they even have their own icon J. This tighter integration makes it really easy to work with forms and to leverage all the structured information they provide without having to leave your familiar Outlook environment. Let’s walk thru a short scenario using InfoPath e-mail forms.
Let’s assume I need to collect information about the computers used by my team. First I need to design a form template to collects this information. For our scenario, InfoPath ships out-of-the-box an Asset Tracking template, which I will use for this example. In order to be sent out safely in email, forms like Asset Tracking need to work only with data from within the form and can contain only declarative logic, no code. Because of these security restrictions we call such forms “restricted” forms. Once the template is completed, I need to deploy it using the Publishing Wizard and selecting the option “to a list of e-mail recipients”. I then need to specify the recipients, add an optional comment, and send out the form. The screenshot below shows the e-mail deployment of my Asset Tracking form:
When a member of my team receives the form, she clicks “Reply”, which opens the form in InfoPath. She then fills out the computer information and sends the completed form back to me, as shown in the screenshot below. She has the choice to send me an editable XML form, which is the default, or to send back just a read-only view. She can also add a comment related to the form in the “Introduction” field. This comment is in fact metadata that travels with the forms. The same field can be used, for example, to ask her assistant to fill out the asset information for her and, for more complex forms, to give instructions on how to complete the form. Here is an example of a completed asset tracking form (In this case I’ve completed it as a team member and I’m sending it back to myself):
Note that at design time I could include a submit button in the form. This will let my team members double-click on the form, edit it in InfoPath and then click “Submit” to send it back to me in e-mail, same as if they replied. However, “Submit” will validate the form and will enforce the return e-mail address. This helps if I need to implement a more formal workflow process using e-mail forms.
Now I’m switching back to being the data collector. I’m expecting to receive a fairly large number of e-mail forms from my team and I want to be ready to process them. To this end, I’m setting up a new Outlook folder to collect the asset data. I right click on Mailbox and select “New Folder”. In the “New Folder” dialog I need to select the option “InfoPath Form Items”, which is new in Outlook 2007, and associates the folder with InfoPath forms. Here is the dialog that creates the “assets” folder for e-mail forms:
Once I’ve created the folder, I can also create a rule that automatically routes incoming asset forms to this folder. This rule should refer to InfoPath forms, as shown in the Rules Wizard dialog below. Then I need to pick-up the specific form type out of the list of all the templates that have been cached on my local machine. For each incoming message, the rule will check if it is an e-mail form of type “asset tracking” and will route all the matching e-mails to the “assets” folder.
Note that forms can be stored in any Outlook folder. However dedicated forms folders will create by default a new e-mail form based on the template associated with the folder. In addition those folders will allow property promotion, as explained below.
When each form is saved into the “assets” folder, the properties that have been market for data promotion in the template are copied as Outlook properties. The forms in this folder can now be sorted and filtered based on their promoted properties, You may know how useful it is to take advantage of promoted properties in SharePoint form libraries. You can see at a glance the work progress captured in weekly status reports or the results of a team survey. The same experience is now also available on your local machine, using e-mail forms and form folders in Outlook. Like in SharePoint, the data stored in form folders can be aggregated and exported to Excel for further processing. Below is an example of asset forms with properties promoted in the “assets” folder:
As you can see, in addition to using the properties promoted from forms, I can take advantage of other properties, like Categories and Flags that Outlook provides for all item, regardless of type. In the example above I’ve flagged the machines that need to be replaced, upgraded, or the new ones that have been purchased in the last quarter.
When I get all the replies from my team, I will go ahead and process the data. As I mentioned before, the data is not in some collection of text e-mail messages that I need to read in order to extract information for my report. It is in a collection of structured forms that I can very easily process and extract the data to report on.
My next step is to export the data to Excel. I select all the forms in the folder and then select the “Export to Excel” option from the toolbar. This option automatically generates a spreadsheet with all the data mapped from the forms into Excel. Note that the export to Excel is not limited to the promoted properties in my folder but rather to the entire XML of each form in the folder. Once I have all the data in Excel, I create a simple pivot table with the number of laptop, desktop, and lab machines for each functional team and then I chart the data using the new graphics engine. Here is the result of my data gathering scenario using the e-mail form for asset tracking:
When should you use e-mail forms?
We’ve seen how I’ve used e-mail forms to gather asset information from my team. E-mail forms could also be used for many similar scenarios, often ad-hoc, in order to collect data quickly from a group of people, via e-mail. Examples are creating a survey for your department, gathering feedback from customer visits, or collaborating with your team on a status report. The common elements of these scenarios are:
- The data needs to be structured – otherwise you’d just use regular e-mail
- The data collection is done ad-hoc – there’s no need to set up a more formal process
- You own the final results – it is ok for the final results to be collected in your own mailbox
Once you have the replies, you could process them as needed and/or share the data with your team. In our example, I am the consumer of the collected information. I will export the data to Excel, review it, and order new hardware as necessary. For status report, the team lead will be assembling the report, then will publish it, and present it to the team.
A broader scenario is using e-mail to make other forms available to your users. Your forms could be part of a formal team scenario like tracking weekly status, a department workflow solution, or an enterprise wide line-of-business application allowing every employee in the company to update benefits or to submit their performance reviews. In all these scenarios, the forms can be delivered, filled out, and submitted in Outlook. We will cover integrated scenarios for e-mail forms in a follow-up post.
Finally an important benefit of e-mail forms is offline filling. As you may know, form templates are automatically downloaded on your machine on first use. Forms can also be installed as part of a client setup. Once you’ve used a form once on your machine, you can fill out any similar forms offline. To make things even simpler, “restricted” form templates can be included in the same message with the actual e-mail form. A user can download the form in Outlook, open it, fill it out, and submit it back as e-mail form. An additional benefit here is that you can complete the form offline, submit it, and be done. The form will be stored in the Outlook Outbox folder and will be sent out automatically next time Outlook connects to your e-mail server.
I hope I’ve been able to give you a sense of the value of InfoPath e-mail forms as first class items in Outlook and get you interested in trying them out in Office 2007. I’ll follow up shortly with other posts on new InfoPath features. Stay tuned! I’d also love to hear your thoughts and feedback.
Comments
Anonymous
February 22, 2006
Great post!
How would this work for email users who do not have InfoPath loaded? Would InfoPath Server render the form as HTML? Or is this a non-possibility for InfoPath e-mail forms?
The reason I ask is for the possibility of mailing forms to users outside of the company and not on Outlook. Is Outlook a key piece of this architecture?
Thanks...Anonymous
February 22, 2006
Hey Phil - if you don't have InfoPath installed, these will appear as emails with attachments and the InfoPath specific UI will not light-up. We always send a static snapshot of the form when sent as HTML, so you'll see that as the message body.
For users outside or not using Outlook 2007 + InfoPath 2007, they'll need to save the XML attachment representing the form and open that up directly inside of InfoPath.
The Form Server does not get involved in this loop.
Cheers,
== EricAnonymous
February 27, 2006
That's what me and my manager were thinking to do with office 2003 yesterday.Premonition!Anonymous
March 23, 2006
PingBack from http://www.fishbrains.com/posts/25Anonymous
April 05, 2006
Everyone likes InfoPath's email data connection because it lets you collect forms using email only, no...Anonymous
June 16, 2006
We have made significant investment in Office 2007 to better integrate InfoPath with Outlook. To that...Anonymous
June 30, 2006
When designing a form template, publish is an important step to make the form available for end users...Anonymous
November 03, 2006
Recently, I did a deep dive on InfoPath 2007 and Forms Services for a couple of customers. They askedAnonymous
December 20, 2006
Encontrei num post do blog do JOPX , este conjunto de recursos sobre InfoPath 2007. General resourcesAnonymous
December 25, 2006
InfoPath 2007 resources General resources InfoPath General Overview InfoPath team Blog Designing FormAnonymous
February 25, 2007
PingBack from http://dsanalytics.com/dsblog/using-microsoft-infopath-for-internal-surveys_67Anonymous
March 18, 2007
Hi, This Blog is very useful for me.Thanks a alot. I am working in Virtual PC. I configuresd the Mailserver in it. But When I take an Infopath form(Asset tracking) and try to publish,it says this form can only be published to a shared location because rich textbox contains linked images..could please tell me why such a message..? thanks in advance... jalAnonymous
March 18, 2007
Hi, This Blog is very useful for me.Thanks a alot. I am working in Virtual PC. I configuresd the Mailserver in it. But When I take an Infopath form(Asset tracking) and try to publish,it says this form can only be published to a shared location because rich textbox contains linked images..could please tell me why such a message..? thanks in advance... jalAnonymous
May 22, 2007
Hi, I have to admit that this post is long overdue. In the last two weeks, I came across a lot of peopleAnonymous
May 22, 2007
Hi, I have to admit that this post is long overdue. In the last two weeks, I came across a lot of peopleAnonymous
May 29, 2007
I really like how Office 2007 integrates infopath with outlook!Anonymous
July 16, 2007
PingBack from http://blogsseek.com/ira-rollover/2007/07/17/asset-tracking-asset-tracking-software-bar-code-asset-tracking/Anonymous
January 01, 2008
The comment has been removedAnonymous
February 06, 2008
Hi, i have a form of infopath that works with a dabatase in SQL. I want to send the form to other user on my organization and i need that the user can edit the data on the SQL database. I published my form, but i think that i'm doing something wrong. How can i do this???Anonymous
February 25, 2008
Emailing forms and documents from one user to another is a common way of performing workflows in businesses.Anonymous
January 21, 2009
PingBack from http://www.keyongtech.com/1235280-email-addresses-from-sharepoint-listAnonymous
March 05, 2009
How can I get InfoPath 2007 emailed forms to work correctly with Outlook 2003? Any help would be greatly appreciated.Anonymous
June 26, 2009
Hi, I need to know if i can publish an InfoPath form to an email recipient and then submit the filled form to a Web Service. Thank You!Anonymous
October 25, 2010
Hi, It's really a nice article.Is it possible to approve workflow task using infopath forms through mail from mobile device? Thanks! Arup www.sudokunext.comAnonymous
November 16, 2010
The comment has been removedAnonymous
May 27, 2011
We currently use InfoPath to submit forms through Microsoft Outlook. (We have InfoPath 2007). We created a purchase requisition that "calculates" when a user is filling it out, but when the receiver receives the form through Outlook and needs to change a dollar amount, the form will not re-calculate the grand total. Is there a way to recalculate once it is in Outlook?Anonymous
March 04, 2012
Perfect post. Here’s a tool that lets youbuild all types of web forms with email alerts fast and without coding. Just point and clickwww.caspio.com/.../web-forms-online.aspxAnonymous
April 04, 2012
Very useful. we send the filled in forms to a mailbox named Systems and that mailbox is added to multiple users Outlook as an "additional mailbox". Users do not see the Promoted fields. However if we log in to a local machine with the Systems account, the promoted fields are there. What needs to be done so that if the mailbox is added as an additional mailbox to multiple users. Thanks in advance.