VBA code running on Server? Shared mailbox email routing

Status
Not open for further replies.

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.
 
Status
Not open for further replies.
Thread starter Similar threads Forum Replies Date
S Skype for business meeting vba code Outlook VBA and Custom Forms 1
R Expand VBA Permanent Delete Code Outlook VBA and Custom Forms 6
B Outlook Business Contact Manager with SQL to Excel, User Defined Fields in BCM don't sync in SQL. Can I use VBA code to copy 1 field to another? BCM (Business Contact Manager) 0
A VBA Code in Outlook disappears after first use Outlook VBA and Custom Forms 1
F VBA to ensure a code is entered in Subject title Outlook VBA and Custom Forms 1
N Open & Save VBAProject.Otm using VBA Code Outlook VBA and Custom Forms 1
R VBA Code to permanently delete selected email Outlook VBA and Custom Forms 10
C Need VBA code to automatically save message outside outlook and add date Outlook VBA and Custom Forms 1
S VBA Code to move mail items from search folder to inbox subfolder Outlook VBA and Custom Forms 4
B VBA Code to create appointment from email Outlook VBA and Custom Forms 1
D VBA Code to strip Subject Line when replying or forwarding Using Outlook 3
M VBA Code to Restart Outlook on error Outlook VBA and Custom Forms 3
Z Default VBA code for extracting data from email (Outlook) to Excel? Outlook VBA and Custom Forms 1
T VBA to Sort Rules [A-Z] - code provided Outlook VBA and Custom Forms 9
M VBA Auto-Reply code for Two Mailboxes on one Outlook Session. Outlook VBA and Custom Forms 4
Z Protecting VBA code - anything new? Outlook VBA and Custom Forms 2
G VBA code to enable a rule based on time of day for a IMAP mail account Outlook VBA and Custom Forms 14
S VBA code to rename a task (flagged message) Outlook VBA and Custom Forms 1
M VBA code to save email attachments (PDF) as email subject line Outlook VBA and Custom Forms 1
F VBA Code to change subject Like Outlook VBA and Custom Forms 3
Diane Poremsky Pasting VBA code (and other editing) Outlook VBA and Custom Forms 4
C Required VBA code to complete task when replied to Outlook VBA and Custom Forms 2
Kelli VBA code for Outlook Using Outlook 1
S Requried a VBA Code to export Calander details to excel... Outlook VBA and Custom Forms 4
M VBA Code to extract data from an Outlook Form Using Outlook 0
M VBA code needed to move from Outlook 2010 subfolder to Symantec Vault subfolde Using Outlook 0
C In need of VBA code to read / parse HTML - Outlook emails Using Outlook 0
R [VBA] complicated(?) outlook events - need help with code Using Outlook 15
R how to get Outlook VBA code to work on the current folder Using Outlook 3
J VBA code can't be completely executed in outlook 2013 Using Outlook 0
D VBA: Send-From Code for Template Shortcut? Using Outlook 0
P VBA Code being completely ignored by Outlook Using Outlook 7
M Updating VBA code from outlook 2007 to outlook 2010 Using Outlook 1
J VBA code to determine 'show' state of SearchBar Using Outlook 7
L Send E-mail with VBA code from [E-mail Distribution Group] if I have “Send as” Using Outlook 6
S Outllok 2007 VBA code to send mail automatically from drafts folder Using Outlook 1
S ThisOutlookSession in VBA not there anymore and code is gone Using Outlook 2
F No Attachment Warning - VBA Code HELP Outlook VBA and Custom Forms 1
J VBA code (rules) won't work after reboot Outlook VBA and Custom Forms 2
N VBA code to show today's date + a sequencial number in subject lin Outlook VBA and Custom Forms 1
A Accessing .pst folder in outlook using VBA Code Outlook VBA and Custom Forms 4
C Beginner Needs VBA Help in Modifying Code Outlook VBA and Custom Forms 2
P 'Trusted' VBA code in Outlook 2003? Outlook VBA and Custom Forms 2
F Recovery of VBA code Outlook VBA and Custom Forms 2
B convert VBA code to Add-in Outlook VBA and Custom Forms 1
B how/what dialog boxes can I display from VBA code Outlook VBA and Custom Forms 1
M Outlook 2013 reminder email by using Outlook vba Outlook VBA and Custom Forms 1
D.Moore VBA script fail after Office 365 update Using Outlook 8
R Limiting length of saved attachment in VBA Outlook VBA and Custom Forms 2
C How to use VBA to show only items x days old or more Outlook VBA and Custom Forms 1
Similar threads


















































Top