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