MS Outlook Voting mismatch

Posted by Robert Ilbrink on Super User See other posts from Super User or by Robert Ilbrink
Published on 2012-03-16T16:55:49Z Indexed on 2012/10/07 9:42 UTC
Read the original article Hit count: 232

Filed under:

outlook

I did send out an Outlook vote to hundreds of employees, using their email address (which is mostly [email protected], but there are many exceptions).

The incoming votes are not matched against the email address, but against the display name. Unfortunately, the display name has no real standard either.

So instead of seeing this:

 [email protected]  Voted: Yes
 [email protected]  Voted: No

I see this:

 [email protected]
 [email protected]
 Doe, Johnathan Philip Voted: Yes
 Doe - Peeters, Marian Voted: No

In the actual list I see the addresses that I sent the vote to PLUS extra lines with the votes that came back.

Is there a quick way to match my "send" list with the "received" list?

One thing I thought of was to dump the global address book in a file and in Excel use =vlookup. But that seems a lot of work (and I am not even sure that I have the authorization to dump the address book).

Related posts about outlook

Outlook 2007 - Cannot start Outlook - Cannot open the Outlook window

as seen on Super User - Search for 'Super User'
I went to open Outlook 2007 on my Windows 7 32bit machine and it came up with this error: Cannot start Microsoft Office Outlook. Cannot open the Outlook window. The set of folders cannot be opened. The information store could not be opened. I have deleted and created a new profile in Control Panel… >>> More
How To Switch Back to Outlook 2007 After the 2010 Beta Ends

as seen on How to geek - Search for 'How to geek'
Are you switching back to Outlook 2007 after trying out Office 2010 beta? Here’s how you can restore your Outlook data and keep everything working fine after the switch. Whenever you install a newer version of Outlook, it will convert your profile and data files to the latest format. … >>> More
Outlook 2007 Backup to D:\Outlook Fails - Access Denied, Write-Protected or File In Use

as seen on Super User - Search for 'Super User'
I can successfully save the Outlook PST file to the default location on the C drive (C:\Documents and Settings\user\ ... \Outlook) but when I change the backup save to directory to Outlook on the D drive I get the error: Cannot copy Outlook: Access is denied. Make sure the disk is not full or write… >>> More
Communication between Outlook addin and Program Automating Outlook

as seen on Stack Overflow - Search for 'Stack Overflow'
I have an application that uses the automation interfaces to Microsoft Outlook to create a mail message and then after it is sent save an archive of that email message in my application. I am hitting issues with a number of the third party encryption addins because by the time the Sent event fires… >>> More
prevent outlook stationery from showing up in my email (Outlook 2007)

as seen on Stack Overflow - Search for 'Stack Overflow'
There are some people in my office who insist on using cute stationery and some of it makes messages difficult to read. I really just want to read email on a white background with no distractions. Is there a way to disable stationery on incoming mail in Outlook? (Without switching to "plain text… >>> More

Developer IT