Solved

Voting and tracking option

Posted on 2010-11-24
12
623 Views
Last Modified: 2012-05-10
I sent an email to a distribution list by activating ' voting and tracking' with 'yes or no ' option.
The users responded to my mail by saying yes or no.
I want to count how many users said ' yes ' and 'no'.
When i check the tracking on my sent mail , it says only '2' for those who said yes and 0 for No. Which is not right. In reality, more than 2 person said 'yes' and 'no'

Do you know how to fix this issue ? Is there any other possible solution to count the number of users said yes and no ?

Thanks for your help
0
Comment
Question by:kriiis
  • 5
  • 4
  • 3
12 Comments
 
LVL 74

Assisted Solution

by:Jeffrey Coachman
Jeffrey Coachman earned 25 total points
ID: 34214660
If I were you I would move this system from Voting buttons (in Outlook) to the new "Email Data Collection" feature in Access 2007.

Then you can use Access utilities to get reports of your results.

So you can not only count the Yes and No reply's, you can get stats like:
How may "Yes" in December.
Average "No" in qtr1.
What Recipient said "Yes" the most.
...ect

here are some links
http://www.youtube.com/watch?v=RXeQeBOPOh8
http://office.microsoft.com/en-us/access-help/data-collection-e-mail-options-HA010030534.aspx

The Access Bible also covers this:
http://www.amazon.com/Access-2007-Bible-Michael-Groh/dp/0470046732/ref=pd_bxgy_b_img_a

;-)

JeffCoachman
0
 

Author Comment

by:kriiis
ID: 34305084
Boag2000 > Sorry for the delay...and thanks for your comments... But it doesnt really helpfull.

There is no way to fix this bug directly on the outlook 2007 ? If no,

Is there any way to export only particular mails ( those who said ' yes ' ) to excel or access file ? and then count the number of person who said 'yes'.


0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 34307091
0
 
LVL 76

Accepted Solution

by:
David Lee earned 100 total points
ID: 34307274
Hi, kriiis.

The code below will count up the votes.  Here's how to add the code to Outlook.

1.  Start Outlook
2.  Click Tools > Macro > Visual Basic Editor
3.  If not already expanded, expand Microsoft Office Outlook Objects
4.  If not already expanded, expand Modules
5.  Select an existing module (e.g. Module1) by double-clicking on it or create a new module by right-clicking Modules and selecting Insert > Module.
6.  Copy the code from the Code Snippet box and paste it into the right-hand pane of Outlook's VB Editor window
7.  Edit the code as needed.  I included comments wherever something needs to or can change
8.  Click the diskette icon on the toolbar to save the changes
9.  Close the VB Editor

To use the code

1.  Select the message containing the votes.
2.  Run the macro.
Sub CountVotes()
    Dim olkMsg As Outlook.MailItem, objDict As Object, arrKeys As Variant, arrCounts As Variant, intIndex As Integer, strBuffer As String
    Set objDict = CreateObject("Scripting.Dictionary")
    For Each olkMsg In Application.ActiveExplorer.Selection
        If Not objDict.Exists(olkMsg.VotingResponse) Then
            objDict.Add olkMsg.VotingResponse, 0
        End If
        objDict.Item(olkMsg.VotingResponse) = objDict.Item(olkMsg.VotingResponse) + 1
    Next
    arrKeys = objDict.keys()
    arrCounts = objDict.Items()
    For intIndex = LBound(arrKeys) To UBound(arrKeys)
        strBuffer = strBuffer & arrKeys(intIndex) & vbTab & arrCounts(intIndex) & vbCrLf
    Next
    Set olkMsg = Nothing
    Set objDict = Nothing
    msgbox strBuffer, vbInformation + vbOKOnly, "Vote Summary"
End Sub

Open in new window

0
 

Author Comment

by:kriiis
ID: 34337338
Thank you very much for the responses.
I havent yet tried the solution.. I will let you know this week...
0
 
LVL 76

Expert Comment

by:David Lee
ID: 34337801
You're welcome.  No problem.  Take your time.
0
Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

 

Author Comment

by:kriiis
ID: 34371515
Hi Bluedevilfan > i tried your script as you said..i selected the mail that i sent and executed the script.But it returns the value 1, for the persons who said 'yes'. But in reality there are more than 50 persons said 'yes'.

Any advise ?

Thanks
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 34372223
...and your opinion of the link I posted?
0
 
LVL 76

Expert Comment

by:David Lee
ID: 34396016
Sorry, I should have been clearer.  You need to select the responses to your message not your message itself.  
0
 

Author Comment

by:kriiis
ID: 34447945
Sorry for the delay, went on christmas holidays :)
Thanks for your reply


0
 

Author Closing Comment

by:kriiis
ID: 34447950
Bluedevin fan >> thanks for your help. It was helpful to solve my issue.

Boag2000 >> Your comments too helpful to understand the concept of voting and tracking options.
0
 
LVL 76

Expert Comment

by:David Lee
ID: 34447958
No worries.  You're welcome.  Happy New Year!
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Check out this infographic on what you need to make a good email signature that will work perfectly for your organization.
MS Outlook is a world-class email client application that is mainly used for e-communication globally.  In this article, we will discuss the basic idea about MS Outlook, its advanced features, and types of MS Outlook File formats.
To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…
Many of my clients call in with monstrous Gmail overloading issues with Outlook. A quick tip is to turn off the All Mail and Important folders from synching. Here is a quick video I made to show you how to turn off these and other folders in Gmail s…

861 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

29 Experts available now in Live!

Get 1:1 Help Now