Solved

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

Posted on 2004-03-29
5
575 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

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Create high volume marketing opportunities using email signatures with these top 10 DOs and DON'Ts of email signature marketing.
Sometimes Outlook might have problems sending a message. There may be various causes- corrupted PST, AV scanner etc. The message, instead of going to the Sent Items folder, sits in the Outbox indefinitely. To remove it you can use a free tool cal…
This Experts Exchange video Micro Tutorial shows how to tell Microsoft Office that a word is NOT spelled correctly. Microsoft Office has a built-in, main dictionary that is shared by Office apps, including Excel, Outlook, PowerPoint, and Word. When …
To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…

708 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

10 Experts available now in Live!

Get 1:1 Help Now