Extract Inbox/Sent Items emails addresses from following fields: FROM, TO, CC, BCC

Hi all,

I need to extract Inbox/Sent Items(OUTLOOK APP) emails addresses from following fields: FROM (Name of the person), TO (Name of the person), CC(Name of the person), BCC(Name of the person) in separate column and if possible to remove duplicate.

On the internet I have found the attached code, but this is not extracting the email from sent items, as they are not defined as an object, and also the BCC fields is missing.

Any help with will be much appreciated.

Thank you,
Ana