On Sun, 10 Apr 2005 19:17:09 +0200, "Macgru" wrote:


Uzytkownik "Peter" napisal w wiadomosci
.. .
Hi,

I have a spreadsheet that is emailed to 8 people every week by means
of a section of a macro. Each of the lines in the macro responsible
for emailing the spreadsheet are in the form

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

I am using Excel 2000 and Outlook 2000 and unfortunatley, as a
protection device, Outlook prompts me 8 times, asking if I am aware a
programme is trying to send a mail on my behalf and do I wish to
contine?

Can anyone please advise if I can somehow disablr this function in
this particular instance?

Alternatively, within outlook it is possible to allocate a number of
email addresses to a group address, such as "Friends" or even
"Enemies"

Does anyone know how I can get such a group address to work within the
macro so at least i am only prompted once!

Any help/suggestions/advise will be much appreciated


--
Cheers

Peter

visit
http://www.rondebruin.nl/mail/prevent.htm
mcg


Hi,

Many thanks for the suggestion. Unfortunately the spreadsheet in
question is on my office PC and we are not permitted (or able) to load
3rd party software :-(
--
Cheers

Peter