Please start playing, the object browser helps you to learn the Outlook
object model: Press f2, switch from <All libraries> to Outlook, and see
what's available. For instance, find and select the ItemAdd event, the press
f1 for help.
Best regards
Michael Bauer
Am Tue, 4 Aug 2009 11:39:01 -0700 schrieb Sam:
> Mike,
> First of all, thank you for responding to my query. The workflow suggested
> by you sounds perfect to me. However, as I am only an intermediate level
VBA
> programmer with no past life in Outlook VBA - I am hoping to learn see
some
> code which I can use. Hopefully this will allow me to play with Outlook
> objects / code, and I would be able to implement it for my organization.
> Thanks,
> Sam
> "Michael Bauer " wrote:
>
>
>
>> This easy aproach might work - at least in theory: Put all of the users'
> > address in an array, so v(0) is the first recipient, v(1) the second,
etc.
>
>> Use a variable on the module level to count the number of received emails
in
> > the session. In the ItemAdd event of your inbox send the next email to
> > v(counter), then increase the counter by 1. If the counter is higher than
> > Ubound(v), set it back to 0.
>
>> This works only as long as Outlook is running, and it doesn't know for
> > whether user 1 for example is on vacation.
>
>> > > Best regards
> > Michael Bauer
>
>> >> >>
>
>
>> Am Mon, 3 Aug 2009 20:47:01 -0700 schrieb Sam:
> >
> >> My organization receives a lot of mails, which I then have to forward to
a
> >> team responsible for attending to the query at the earliest. The logic
to
> >> follow is - 1st mail goes to user 1, 2nd to user 2 and so on, continuing
> > in
> >> cycle.
> >
>>> Currently I have a person to do this manually. I would like to know how
> > this
> >> can be automated using VBA, such that any new mail gets assigned
> >> automatically.
> >