MS Outlook Voting mismatch
- by Robert Ilbrink
I did send out an Outlook vote to hundreds of employees, using their email address (which is mostly firstname.lastname@company.com, 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:
John.Doe@abc.com Voted: Yes
Mary.Doe@abc.com Voted: No
I see this:
John.Doe@abc.com
Mary.Doe@abc.com
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).
