Solved

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

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

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

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

Suggested Solutions

What does UTC stand for?  “Coordinated Universal Time” – Think of this as the true time on Planet Earth that never changes with the exception of minor leap seconds here and there to account for the changes in the planet's rotation.   What does th…
Are you unable to connect or configure Hotmail email account in Microsoft Outlook 2010, 2007? Or Outlook.com emails are not downloading to Outlook? Lets’ see the problem and resolve Outlook Connector error syncing folder hierarchy (0x8004102A).
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…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

792 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