Solved

extract voting information from Outlook 2007

Posted on 2009-06-29
3
355 Views
Last Modified: 2012-05-07
Hi,

When you send an email with voting options at the top of the email responses you get back there is a can section containing the senders response. Right click on this and you can view voting responses, which is a detailed list of how people responded to the email.

I am trying to get this voting information out of some emails and put it into some other format, e.g. XML or a text file.

Can anyone explain to me how to do this ? Preferably with a VB Script or VBA Macro

Regards

Ertnev74
0
Comment
Question by:ertnev74
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 76

Accepted Solution

by:
David Lee earned 500 total points
ID: 24735978
Hi, ertnev74.

Here is some sample code that extracts the voting information from the sent item.  This sample displays the response int eh immediate pane of the code editor.  You can change it to output the information in XML, CSV, etc.
Sub VotingResponses()
    Dim olkMsg As Outlook.MailItem, olkRecipient As Outlook.Recipient
    Set olkMsg = Application.ActiveExplorer.Selection(1)
    For Each olkRecipient In olkMsg.Recipients
        Debug.Print olkRecipient.AutoResponse
    Next
    Set olkRecipient = Nothing
    Set olkMsg = Nothing
End Sub

Open in new window

0
 

Author Comment

by:ertnev74
ID: 24761372
Hi BlueDevilFan,

I have tried this but I only seem to be able to extract the first set of response info from the email, even though the report contains multiple entries.

Any suggestions ? I think it might have something to do with it check the recipients ? Is it possible to code a lone similar to this one ??

    For each voteresponds in objectmsg.voteresponses ????

Regards

Ertnev74
0
 
LVL 76

Expert Comment

by:David Lee
ID: 24761481
"I only seem to be able to extract the first set of response info from the email"
I don't understand what you mean by "first set of response info".  Do you mean that it only returns one person's vote and not the vote from all recipients?

"For each voteresponds in objectmsg.voteresponses ????"
That's exactly what the code I posted does.  Each recipient has one vote and that vote is stored in the "AutoResponse" property.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Outlook Free & Paid Tools
Many people use more than one email account and so it becomes difficult for them to manage them when they use separate accounts,  so, in this article, I have shared an easy way to add Other Mail Accounts in your Google Inbox. It helps to combine all…
CodeTwo Sync for iCloud (http://www.codetwo.com/sync-for-icloud?sts=6554) automatically synchronizes your Outlook 2016, 2013, 2010 or 2007 folders with iCloud folders available via iCloud Control Panel. This lets you automatically sync them with…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

762 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