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.