Export emails from Outlook to Excel

I want to move my emails into an Excel file. I have found this code and it works, but there are a few things I would like to change but don't know how.

Right now the code needs a manual selection of which folder to export from and I would like to automate this. It also opens the file every time the code is run even if the file is already open, I would like it to select the file if it is already open instead of opening a second one. Then, I would like to put this into a script that will run on outlook every time a new message is received. Please help me with any of the problems if you can. Thanks.

Please Login or Register  to view this content.

you may do like this
choose file > export > address book. Export as a csv file. this can then be opened it excel
and if if you need some other way you can contact PST repair.