Running a VBA script on a public folder from the server (Exchange 2000, Outlook 2003)

Hi there,

I have created a vba script that scans any mail in a public folder and where needed update a database with details from the email. I have it working on demand fine from Outlook but I wish to move it to the exchange server so it can run all hours. I also wish to have it 'fire' when new mail is received, however I suspect I can manage that part fine once I have found where to place it on the server.

I have been given admin rights to the exchange server and the Microsoft exchange event service is running. I have owner permissions on the public folder.

Any help will be appreciated.
GryffAsked:
Who is Participating?
 
bruintjeConnect With a Mentor Commented:
exchange vba is a bit different object model and version dependent using CDO or CDONTS for exchange 2K and up but you could have a look to start at this script

title: Public Folder Update Notification
source: http://www.cdolive.com/pfalert.htm

hope this helps a bit
0
 
GryffAuthor Commented:
Ok, I think I can modify my script as needed for CDO, however I am still having problems finding where to actually stick the script. The website you gave me said....

Use the Microsoft Exchange admin program to add the 'PFAlert' mailbox to the 'Folders\System Folders\Events Root\EventConfig_<Your Servername>' folder with 'Author' (or greater) permissions to make sure that this mailbox can create and modify Microsoft Exchange Server Scripting and Routing scripts.

...However this and all the other notes I can find are written with exchange 5.5 in mind. I cannot find a similar setting within Exchange 2000's System Manager. I have found an 'Events Root' folder but cannot determine how to add my public folder in a manner as described.

Also I cannot find an 'Agents' on the folder, though that may well be because I have not been able to do the step mentioned above.
0
All Courses

From novice to tech pro — start learning today.