Hi,
I wanted to get only encrypted emails from outlook in excel, I searched a log but I didn't get the right solution, I used mailItems.Categories but this is not the right attribute. Please help me.
Thanks in advance.
Shiva
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
encrypted outlook mails
0
Answers
0
It looks like you just need to test the MessageClass of the Mailitem to see if it is encrypted.
The encrypted messages should look different than regular messages and you can determine exactly what you need to look for when testing on your system; just check some encrypted messages and non-ecrypted messages and look at the output.
Here is the reference to the MessageClass property and Mailitem object from Microsoft:
I don't have working Outlook on my computer right now so I can't test this, but let me know if it helps!