Email from macro problem
"Peter" wrote in message
...
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
One solution
In Outlook Express, and prabaly in Outlook", select Tools|Options. Selct the
security tab. Uncheck "Warn me when other applications try to send mail as
me". Not very safe
You can also select Tools|Address Book... A new window will appear and you
can create an ew group from the File menu. you should be able to use the
name you give to this group. This should give you one warning, I think.
/Fredrik
|