Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Alert message during Activeworkbook.sendmail
Everything you wanted to know about e-mailing but were affraid to ask is
right here... http://www.rondebruin.nl/ I have some code that does the Yes answer if you want, but try this first... HTH "N10" wrote: 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Alert message during Activeworkbook.sendmail
"Jim Thomlinson" wrote in message ... Everything you wanted to know about e-mailing but were affraid to ask is right here... http://www.rondebruin.nl/ I have some code that does the Yes answer if you want, but try this first... HTH "N10" wrote: 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 Jim Thanks for the reply :) Im going to follow the link and see what I can learn. Best N10 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Alert message during Activeworkbook.sendmail
Hi Jim
Many thanks for the link...problem sloved :) Best N10 "Jim Thomlinson" wrote in message ... Everything you wanted to know about e-mailing but were affraid to ask is right here... http://www.rondebruin.nl/ I have some code that does the Yes answer if you want, but try this first... HTH "N10" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |