browneye9000
asked on
Outlook voting button no response summary
I asked a question that was very similar to this question before. The ID of the old question was ID: 22664290 and Blue Devil Fan helped me with it. His reponse was exactly what I was looking for.
Our team used to use voting buttons as an acknowledgement that the email was read. The emails were sent out to groups of people who needed to know about a change in the organization. We kept the emails that were sent out and used the tracking tab as records that the people had acknowledged the change. It took us about a year but we realized that this was ineffective because many people did not acknowlege. Now we have over 100 emails with missing acknowledgements.
The emails would be sent out with the subject of the change as the subject line of the email. What I am looking for is a macro that can summarize what the subject of the email was and who did not acklowedge. We can then go back and find out who needs to perform a retroactive acknowledgement of the change.
We stored all the emails as .msg files in a specific directory. Can someone please help with writing a macro that can search for voting button emails and create a summary of the subject lines and below each subject line create a list of those who did not acknoweledge? If necessary I can send a few examples of these emails to someone if they need to play around to get it to work correctly.
Our team used to use voting buttons as an acknowledgement that the email was read. The emails were sent out to groups of people who needed to know about a change in the organization. We kept the emails that were sent out and used the tracking tab as records that the people had acknowledged the change. It took us about a year but we realized that this was ineffective because many people did not acknowlege. Now we have over 100 emails with missing acknowledgements.
The emails would be sent out with the subject of the change as the subject line of the email. What I am looking for is a macro that can summarize what the subject of the email was and who did not acklowedge. We can then go back and find out who needs to perform a retroactive acknowledgement of the change.
We stored all the emails as .msg files in a specific directory. Can someone please help with writing a macro that can search for voting button emails and create a summary of the subject lines and below each subject line create a list of those who did not acknoweledge? If necessary I can send a few examples of these emails to someone if they need to play around to get it to work correctly.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Thanks and you're welcome!
ASKER
Ran the macro and found out that it is pulling everyone on the voting list. Not just those that have no response to the vote. Also, if possible, I would also like to have the macro pull names that indicate the word "DELETED" beside it. This indicates that the person never acknowledged the email but just deleted it.
"Ran the macro and found out that it is pulling everyone on the voting list"
I've run the macro several times against voting messages I have and it always works correctly. Did I misunderstand what you wanted to accomplish? This macro is desgined to work only with messages that employed voting buttons. The macro doesn't pay any attention to whether the message was read, it only checks to see if the recipient voted. If they didn't vote, then they go on the list.
I've run the macro several times against voting messages I have and it always works correctly. Did I misunderstand what you wanted to accomplish? This macro is desgined to work only with messages that employed voting buttons. The macro doesn't pay any attention to whether the message was read, it only checks to see if the recipient voted. If they didn't vote, then they go on the list.
ASKER
You are exactly right. I tried to apply it to a different type of file that we had sent out. Once I got my head out of my *@^# I realiized that I wasn't doing it correctly. Sorry for bothering you.
No problem. If you need another version that checks to see if messages were deleted without being read, then I can modify this code to do that.
ASKER