Create a query dynamically for every subfolder in an exchange mailbox
Posted on 2006-11-27
We have an exchange server mailbox that we track workflow out of. A webform creates an email message into this mailbox. Once there 1 of houndreds of people have rights to move this message around, placing it in subfolder upon subfolder. I have manually linked over 250 mailbox subfolders using Access. I then created a vb function to create 1 MT query and 249 append queries based on the linked tables. The problem comes in that any one of those houdreds of people have the ability to create a subfolder, at that point I lose visibility of the messages.
What I am looking for is a way to dynamically link to all folders in an exchange server mailbox, then create an append query for each linked table, then run it.