If you support internal users at your organization, you need to know what they think of your service. Customer satisfaction surveys are indispensable for identifying problem areas and documenting excellent service to upper management. If you already have a survey process in place, consider the following functionality to enhance it. And if you aren't getting feedback from your users, it's never too late to start.
I've created a survey system that uses custom Outlook forms published to the Exchange Organizational Forms Library so that all users can open and view the forms. If you can't get publishing access to this library, you'll have to look for an alternative process. Also note that these forms are available only in Outlook; Outlook Web Access (OWA) or other email programs can't see the forms.
I chose Outlook as my survey-distribution method to improve response rate. I've participated in various survey methods over the years, including calling users directly and sending them to Web forms. And I've found that people are more likely to respond to a survey if it's easy for them to participate. This solution presents users with a single form and gives them convenient multiple-choice selections. Since I've been running this system, my organization has sent out 2391 surveys and received 1194 responses, which represents a response rate just shy of 50 percent. When we directed users to a Web form, we were lucky to see response rates of 20 percent to 35 percent. I hope you'll experience as much success with this system as I have.
In this article, I walk you through creating the survey system in two stages. After completing the first stage, you'll have a custom Outlook survey form that you can manually send and collect. The surveys come from whoever initiates the survey distribution, and they're returned to a single email account of your choosing for manual processing of the survey results. The second stage lets you automate survey distribution and collection. To complete the automation process, you need Microsoft Office Outlook 2003 and a ticket-tracking system accessible through a database connection. The database gathers the survey recipient's email address and a reference or description of the ticket or incident the survey covers. My example uses a Microsoft SQL Server database, but you can easily modify it to reflect your environment.
Creating the Launch Form
The basic form that launches the survey simply populates the response form and assigns the return email address for the survey collector. To design the form, from the Outlook menu, go to Tools, Forms, Design a Form. In the Standard Forms Library option, choose Message, then click Open.
The only modification you need to make to this form is adding some VBScript code. To enter the code, open the Script Editor, which you can find in the menu under Form, View Code. In the Script Editor, enter the code that Listing 1 shows. You want recipients to use the survey launch form to compose a message to you, not reply to your message. So, the code prevents the item (the original launch form) from opening and instead opens a response form for the user in the Outbox. Be sure to read the code comments in Listing 1 and modify the script to provide a valid email address for the user or account you want to receive the completed surveys.
After you add the code to the survey launch form, close the Script Editor. Then, publish the form by going to Tools, Forms, Publish Form As, and save the form to the Organizational Forms Library. Give the form a descriptive name such as Launch Survey. If you choose a different name, make sure you remember it because you'll reference it later. Say no if asked to save form definitions. Close the form designer, and say no again when asked to save changes. The changes you made were saved when you published the form.
Creating the Response Form
The response form is what users see and respond to. My sample survey form contains four multiple-choice questions and one comments area. You can expand this form by using your own layout and wording. To create the response form, go again to Tools, Forms, Design a Form, and choose the Message form from the Standard Forms Library.
In the form designer, make sure the Edit Compose Page is selected, then begin by deleting all the page elements (i.e., To, CC, Message body) except the Subject area. You use the Subject area to reference the survey topic. Use the Toolbox to add labels for your survey questions or any title text. If the Toolbox doesn't appear by default, you can access it from the Forms menu by clicking Control Toolbox, which opens the Toolbox in a dialog box.
Next, add a combo box beside each question and provide a large text area for any comments. Figure 1 shows an example of how the completed form might look. Notice that I resized the Subject text box and changed the Subject label's caption to read Reference. Feel free to change the layout or font or add or remove questions to suit your needs. Any changes you make at this point are purely aesthetic and have no effect on the form's function.
After you've designed your response form, you need to add user-defined fields to the form. Begin by right-clicking a combo box and choosing Properties. On the Value tab, click New, and provide a descriptive name for the question the combo box is associated with. In this example, I named the first question OverallSatisfaction. After creating the field name, assign possible field values, separating them with a semicolon, as Figure 2 shows. Repeat the process for the remaining combo boxes. I named the other combo boxes TimeSatisfaction, Tech-Satisfaction, and ConfidenceSatisfaction and called the text area UserComments. Don't forget to select the text-box properties option to allow multiline text. And for the comments box, set the field's initial value to nothing by entering empty double quotes ("").
Now select the Edit Read Page option in the form designer to design what the survey will look like when it's returned. Delete the text area for the message body, and open the Field Chooser. (If you don't see the Field Chooser in the Toolbox, you can access it in the Forms menu.) In the Field Chooser, change the drop-down option to User-defined Fields in Inbox. Drag each field you just created onto the form. You can rearrange and resize the text boxes as you want. And, again, don't forget to set the text boxes to handle multiline text. You can also edit the captions to be more descriptive. Figure 3 shows what the returned survey form might look like.
To finalize the form, on the form designer Properties tab, check the box on the right side to Use form only for responses. Optionally, you can use the Version field at the top right to set a version number for the form. By giving the form a version number, you can use the Help, About This Form dialog box to pinpoint which version is in use if you need to troubleshoot any problems. Publish the form by going to Forms, Publish Form As, selecting the Organizational Forms Library, and naming the form Survey. If you choose a different name, it must match the form name in Listing 1. After publishing the form, you can close it, saying no if asked to save the changes or form definitions.
You now have a fully functioning manual survey system. To send a survey from Outlook, select File, New, Choose Form. In the Look In drop-down list, choose Organizational Forms Library if it isn't already selected, then select the Launch Survey form and add the recipient's email address. In the Subject line, provide a description of the incident you're requesting feedback about.
The email address you provide in Listing 1 as the survey collector will receive the responses. To collect the results manually, you need access to that email account (or if it's a distribution list—DL—you need to be a member of the list). You then need to open each message to see the survey responses. To compile the responses, you have to either transcribe or copy and paste the information to another location, such as a Microsoft Excel spreadsheet.
Automating the Process
Automating these processes requires adding some Visual Basic for Applications (VBA) code to the Outlook client from which you'll be sending the surveys. I recommend using Outlook 2003 so that you can digitally sign the VBA code to allow macros to run without lowering your security setting. You can use earlier versions of Outlook, but to avoid security prompts, you'll have to adjust the security setting to Low or Medium, which isn't recommended.
So before adding the VBA code, you need to open Outlook under the mail profile of the account you'll be sending from and check your security settings. Under Tools, Macro, Security, check that the security setting is anything except Very High. The default is usually set to High. In addition, under Help, About Microsoft Office Outlook, verify that Security Mode is set to User Controlled. If it's set to Administrator Controlled, check with your administrator about making an exception. The administrator could either turn off administrator control by using a Group Policy Object (GPO) setting or could allow an exception in the Outlook Security Settings folder to enable this user to send items without getting a prompt. An exception would be the only choice if you're using Outlook 2002 or Outlook 2000. Make sure that changing any of these settings doesn't conflict with your organization's security policies.
Next, you need to create a digital certificate to sign your VBA code, which lets you enable the code even with Outlook security set to High. Locate the Microsoft Self Certification wizard, usually called selfcert.exe and found in the root of the Office folder in your Program Files folder. When you run the wizard, it prompts you to enter a certificate name. Give the certificate a descriptive name such as SurveyCertificate. Return to Outlook, and open the Outlook Visual Basic editor using Alt+F11 or by going to Tools, Macros, Visual Basic Editor. Under the Tools menu, select Digital Signature. Click Choose, and select the certificate you just created. After you add any code in the following sections, you'll need to close Outlook to save the project and reopen Outlook to enable it. When you reopen Outlook, you'll see a message like the one that Figure 4 shows. Check the box to always trust, then enable the macros.