Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Responding to Outlook Errors when useing Sendmail!!
Hi: I am using the "sendmail" command to automatically send an E mail and attachment from an Excel spreadsheet.When I use the command, Outlook responds with a message warning the user that someone is trying to automatically send an e mail, and asking them if this is OK. If the user responds YES, then everything goes smoothly. However, if they respond NO the macro containing the command ends prematurely, and I am left with a user looking at some odd figures on a spreadsheet, rather than the main sheet or a menu. I need to know how to make the system respond in some sensible way to the NO answer to the question, I believe that this is ties up in exception processing, but have no idea how to trap it. Really all I need is some way to programmatically capture the negative response and use programming to bring the event to some clean closing. Can anyone point me in the right direction? Regards John Baker |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Return while useing CONCATENATE | Excel Discussion (Misc queries) | |||
setup and useing a barcode reader | Excel Discussion (Misc queries) | |||
Excel Outlook Attachments opening after several errors everytime | Setting up and Configuration of Excel | |||
when useing the find option in excel | Excel Discussion (Misc queries) | |||
useing arrows to move | Excel Discussion (Misc queries) |