Tasks - Possible

[phil999]

Hi,

I am not sure if this is possible if it it i would be most greatful if someone could point me in the right direction.

So i have 3 different DL's

called DLA 2 users
called DLB 2 users
called DLC 2 users

each having 2 members.

I want to create a task and then have it automatically send to a different member every week on say friday.

So it would be like this

dl A user 1
dl A user 2
dl B user 1
dl B user 2
dl C user 1
dl C user 2
then it would start again
dl A user 1

Thanks in advance for any help

[phil999]

I have been looking around and the more i think about it a task is not really required i could just send an email.

Looking at post thread 5291

and the following code

Sub Send_Sand_Lab_Data()
Dim objol As New Outlook.Application
Dim objmail As MailItem
Set objol = New Outlook.Application
Set objmail = objol.CreateItem(olMailItem)
With objmail
objmail.Recipients.Add ("DL") ' Name of distribution list in Contacts 'Add Somebody on Fridays
If Weekday(Date) = 5 Then objmail.Recipients.Add ("anybody@nfco.com (janybody@nfco.com)") 'Name of somebody@hotmail.com Contact
objmail.Recipients.ResolveAll
.Subject = "Sand Lab Data"
.Body = ""
.NoAging = True
.Display
End With
Set objmail = Nothing
Set objol = Nothing
SendKeys "%{s}", True
End Sub

could i change this
user 1 on week 1
user 2 on week 2
user 3 on week 3
etc etc ie it would cycle through either names inside a DL or just a manual list of names.

I am happy to create the contacts manually.