Thanks for the code. I'm using the VBA code of this page. Is there a way to add a sorting code after the unique values are extracted so it sorts it automatically?

Very useful. Thanks for posting!

thanks for share.
Mini Tractor price 

Nice!
Thanx for sharing the story
Ashok Leylend Truck 

I know that this is necroposting but I had the same issue following similar instructions. What I had to do was create a self signed digital certificate for my macro. (located C:\Program Files\Microsoft Office\root\Office16 for my install of Office 365.) Then I saved it. Then I opened up (alt+f11) and under Tools->Digital Signature for the macro I created I signed it with my self signed cert. Then I went to File->Options->Trust Center>Trust Center Settings>Macro Settings and selected "Notifications for digitally signed macros, all other macros disabled". Click okay. Run your macro it'll warn you about it and you select "Trust all macros from this publisher". You can always check the certificate to see if its the correct one too. Hope this helps someone!

A corporate account pwd is outdated so I get popups every other minute - your method does not work (even after restart) and get rid of the security warning (re-focus window, stop syncing, ...)

on line 9 , removing "On Error Resume Next"  worked for me.

In LibreOffice I found [color10] was blue and [color3] is a darker green

@AbnerThe formula is working great, however there are a few examples where it doesn't recognize

Hello, that's brilliant! How can I adjust the code to only save email attachments, not the entire message? Many thanks