Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Mutiple names in ActiveWorkbook.SendMail Recipients:= | Excel Discussion (Misc queries) | |||
ActiveWorkbook.SendMail | Excel Programming | |||
ActiveWorkbook.SendMail Security Warning | Excel Programming | |||
default mail program -activeworkbook.sendmail | Excel Programming | |||
Activeworkbook.sendmail | Excel Programming |