I have a difficult problem to solve, hopefully someone here can point
me in the right direction. I am pretty familiar with VBA in Access and
used to use VB script, but don't know where to start.

I want to be able to automatically respond to a lead when it comes in
to a sales inbox. I think I can set up a rule to do that, and also use
a rule to do that during normal business hours?

The other thing I need to do is forward that lead to the first
salesperson on a distribution list, or Access Table, the next lead to
the second salesperson, the third lead to the third salesperson etc.
until the end of the distribution list, then start over. I will also
need to modify the distribution list to suit each salesperson's day
off. Somewhere around 100 - 150 leads needs to be handled in that
manner.

Is there a way to loop through a list and accomplish what I'm
describing?

Thank you in advance for your help!

Bob