VBA code running on Server? Shared mailbox email routing

Dino2012

Member
Outlook version
Outlook 2007
Email Account
Exchange Server
Hi -

I'm starting to create some VBA code that will move incoming emails to a generic inbox and and move them to people's folders.

My question is rather basic: how can a developer control where (and thus when) code will execute?

Specifically if I am able to create logic that moves emails from a main/generic inbox to other folders, but I want it to run even when My PC is not running - how can the logic be made to run on the server?

I want to make sure I don't create something that does what I want - but then find out I have to keep my PC running so it will function.

Thanks!
 

Dino2012

Member
Outlook version
Outlook 2007
Email Account
Exchange Server
Why is it that most rules defined for the shared inbox WILL run on the server, but VBA code and rules that RunScript code run on the Client only?

Essentially, the code would be called for email that passed by about 10 Outlook rules without action - and then sequentially allocate (move) the new messages from the shared generic inbox to one of the user email boxes (sub-folders).

Is there an existing drop-in solution that can do this kind of "round robin" distribution of inbound emails? I have not used VBscript - and I don't know if the email system admin would like loading user scripts. Also, the process / rules will probably need to change over time and I would like to have the ability to tweak the solution. I have the list of specs and was about to flow-chart before coding. Do you have any suggestions?

Thank you.
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
Because the VBA script is stored on the desktop. This is the same reason why you can use rules that move messages to a pst file on the server.

Based on what you are doing, I don't think an event sink will work - it would be better to use Outlook, leaving a system run 24/7 if necessary. The last rule will be a run a script rule that moves the mail.

Here is a newsgroup post from years ago - Help with mail forward to different users (round robin) - Outlook Banter - that might give you some ideas on the round robin part.
 

Top