Thanks for reading.
Ok, so I have a well established bit of code which sits happily on a machine reading the contents of a public mail folder through Outlook, stripping off attachments and recording the path to which they were saved, taking the HTML from the e-mail and putting it in a rich text field, and identifying key words in the subject line which prompts users to do various things with the content.
My problem is that every so often Exchange needs to restart, and this machine loses contact with the public folders. Apparently when Outlook first opens, public folders are not populated to save on overheads. It takes a user to manually browse them from Outlook to initialise them. Only then can they be accessed through VBA.
This means that someone has to manually log on and poke the public folder, which I'd rather didn't need to happen.
I've tried all I can think of, including using the popular "GetFolder" function, then telling Access to .Display the folder. This simply fails (no error, the window just closes as soon as it opens). GetFolder does seem to be able to retrieve the folder successfully though.
Does anyone know a way to initialise Outlook public folders from VBA in Access?