P
Peter
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 (e-mail address removed), Format(Range("C2"), "dd-mmm-yy"), True
Any help/suggestions would be very much appreciated
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 (e-mail address removed), Format(Range("C2"), "dd-mmm-yy"), True
Any help/suggestions would be very much appreciated