Send Mail question

[Peter]

Hi,

I have an 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 (e-mail address removed), Format(Range("C2"), "dd-mmm-yy"), True

Any help/suggestions would be very much appreciated.

Cheers

Peter

 

[Brian Tillman]

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 think this is an incorrect assumption. While I haven't tried it, I
suspect that you'd still get nine prompts as Outlook expands the DL.

If you want to save yourself eight of the prompts, create a mailing list on
the server (if you have any access to it) so that you access only a single
address or see the following page to see if there's something that can be
used to address the issue:
http://www.slipstick.com/outlook/esecup.htm#autosec