Currently we have 1 generic mailbox that we use in Outlook. At present 1 of the staff splits all incoming mail up evenly between 4 people. What we would like to do is automate this process. We would like this round robin forwarding to occur as the mail comes in.
Are there built-in functions in VBA to handle this?
So, to review:
1st mail comes in -> Send to person 1
2nd mail comes in -> Send to person 2
3rd mail comes in -> Send to person 3
4th mail comes in -> Send to person 4
5th mail comes in -> Send to person 1
6th mail comes in -> Send to person 2
Are there built-in functions in VBA to handle this?
So, to review:
1st mail comes in -> Send to person 1
2nd mail comes in -> Send to person 2
3rd mail comes in -> Send to person 3
4th mail comes in -> Send to person 4
5th mail comes in -> Send to person 1
6th mail comes in -> Send to person 2