I think a lot of threads start this way, but this seems like it should be simple.
I want to programatically, through VBA, download an outlook folder into a table in access.
From my reading, it seems the best way to approach this is for the multiple users to set up a folder with the same name. My goal is for when any one of us opens the database (or some other trigger, haven't quite decided yet) it will look for a certain folder, and download the contents to a table. Let's just call the folder TEST for now. If everything works right, all user's emails will be merged into one table in access, and we can keep track of all the traffic for our customers who forget to "reply to all" or use the CC line.
All of the guides I've found so far want to do things that are much more convoluted. I haven't been able to decipher the processes I need. I'm not very fluent with this level of VBA, but I'm eager to learn as much as I can here. I'm confident once I've got the transfer process working, I can retake the helm on how to present and/or filter this data.
Any help you guys can offer will be much appreciated.
I want to programatically, through VBA, download an outlook folder into a table in access.
From my reading, it seems the best way to approach this is for the multiple users to set up a folder with the same name. My goal is for when any one of us opens the database (or some other trigger, haven't quite decided yet) it will look for a certain folder, and download the contents to a table. Let's just call the folder TEST for now. If everything works right, all user's emails will be merged into one table in access, and we can keep track of all the traffic for our customers who forget to "reply to all" or use the CC line.
All of the guides I've found so far want to do things that are much more convoluted. I haven't been able to decipher the processes I need. I'm not very fluent with this level of VBA, but I'm eager to learn as much as I can here. I'm confident once I've got the transfer process working, I can retake the helm on how to present and/or filter this data.
Any help you guys can offer will be much appreciated.
