We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

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

Gryff
Gryff asked
on
Medium Priority
649 Views
Last Modified: 2008-02-01
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.
Comment
Watch Question

Freelance
Top Expert 2006
Commented:
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview

Author

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.
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a free trial preview!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.