extract voting information from Outlook 2007

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
ertnev74Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

David LeeCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
ertnev74Author Commented:
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
David LeeCommented:
"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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Outlook

From novice to tech pro — start learning today.