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:
John[email protected] Voted: Yes
[email protected] Voted: No
I see this:
John[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).