Sending mails to Distribution Lists within Outlook 2003

[shavenlunatic]

I'm trying to send a bunch of reports from within Outlook 2003. Now, ive managed to generate the email, attach the files and send them to specified emil addresses. So my question is all depending on what can be done:

If I can set to email to a distribution list, how do I do this?

If i can't mail to a DL, how would I just manually (uhrg) add each email address to the "To" box?

incidentally, heres the code as it stands:

    Set App = CreateObject("Outlook.Application")
    Set Itm = App.CreateItem(0)
With Itm
    .Subject = "Agent Idle Report " & holddates1
    .To = "barry.mcclelland@nottellingyou.com"
    .Body = "Good Morning"
    .Attachments.Add idlelocation1
    .Send
End With
Set App = Nothing
Set Itm = Nothing

thanks in advance

 

[shavenlunatic]

Never mind, figured out my own question, I thought it was a lot more complicated than purely typing the name of the distribution list in between the quotes and having outlook automatically figure it all out.

Maaan, im stupid Sorry for making you read this if you have

clueless

 

[VicRauch]

For those of us that are even more clueless, what was the solution?

 

[shavenlunatic]

as i said, i just typed the name of the distribution list in between the quotes....

for example

.To = "VM Agent Idle Report Distribution List"

simple as that, works with GAL entries too, a-la "Dave Smith" will bring up the relevant guy too... swanky

clueless