View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
N10 N10 is offline
external usenet poster
 
Posts: 141
Default Alert message during Activeworkbook.sendmail

Hi

During operation of one of my macros I have the requirment to send between
1 and 20 copies of a workbook by email

This is easily achieved of course with a series of commands in the following
format

ActiveWorkbook.SendMail , Subject:="MIMSUPDATE"

Operating with XP pro and Excel 20303 An item.send alert message comes up
at each instance of sending via code mail. This message requires a yes no
or cancel input before processing a single mail item.

I need to know if any one familar with this "alert message " knows of a way
to suppress ( or default "YES" it via code) it as it is inconvenient to
authorise lots of email transactions for a system that is fully validated.

Thanks

N10