Hi,

I have a Excel macro that, among other things, emails a spreadsheet to
9 recipients using Outlook. Each time it initiates a send procedure, I
get an Outlook warning telling me that:

A program is trying to automatically send e-mail on your behalf.
Do you want to allow this?
If this is unexpected, it may be a virus and you should choose "No"

I get this for each of the 9 emails and have to choose yes each time.

My question is this: I know I can create a distribution list in
Outlook, and put all 9 email addresses in it - does anyone know how I
can get my macro to use the distribution list to send the e-mails? If
so then I would only have to click "Yes" once.

I am using Excel 2000 (9.0.7616 SP-3), Outlook 2000 SP3 (9.0.0.6627).
The macro line that sends the e-mail is:

".SendMail , Format(Range("C2"), "dd-mmm-yy"), True

Any help/suggestions would be very much appreciated