Solved

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

Posted on 2004-03-29
5
578 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.
0
Comment
Question by:Gryff
5 Comments
 
LVL 44

Accepted Solution

by:
bruintje earned 250 total points
ID: 10703246
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
 

Author Comment

by:Gryff
ID: 10703539
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

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SBS 20011 to Office 365 7 85
Searching Outlook Email Archives 5 31
Microsoft Edge, Outlook OWA 7 41
Outlook importing calendar entries 6 63
Resolve DNS query failed errors for Exchange
Find out what you should include to make the best professional email signature for your organization.
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
Many of my clients call in with monstrous Gmail overloading issues with Outlook. A quick tip is to turn off the All Mail and Important folders from synching. Here is a quick video I made to show you how to turn off these and other folders in Gmail s…

912 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now