View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JP[_4_] JP[_4_] is offline
external usenet poster
 
Posts: 897
Default Automated e-mail from Excel

Check out

http://www.outlookcode.com/article.aspx?ID=52
http://www.rondebruin.nl/cdo.htm
http://www.contextmagic.com/express-clickyes/

HTH,
JP

On Mar 7, 3:46*pm, IvanM wrote:
I have a macro that sends selected spreadsheets to different groups of
employees. *The macro scans down a list of receipents, sending the
appropriate file to each internal e-mail account. *I use the SendMail command
to execute the send via Outlook. *The problem I have is that a anti-spam
protection has been put in place that requires me to "man" the e-mail
process. *Before each send, Excel waits for 5 seconds and then requires me to
confirm the e-mail. *Does anyone know of a way around this protection? *
Thanks