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: 256

Filed under:

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).

© Super User or respective owner

Related posts about outlook