Send Mail question
 

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

Send Mail question
 

Hi Peter

Use a array with all 9

..SendMail ", "), _
"This is the Subject line"

See also
http://www.rondebruin.nl/mail/prevent.htm




--
Regards Ron de Bruin
http://www.rondebruin.nl



"Peter" wrote in message ...
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