outlook vba - excel

Im looking to export outlook emails to an excel file using vba. Lots of code online but each one has some subtle differences. this one is fit for purpose (https://www.sqltreeo.com/docs/vba-script-reads-outlook-mailbox) but just cant seem to get it going.