LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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





 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Mutiple names in ActiveWorkbook.SendMail Recipients:= daleatshel Excel Discussion (Misc queries) 2 February 5th 07 08:06 PM
ActiveWorkbook.SendMail Sandy Excel Programming 2 March 15th 05 07:17 AM
ActiveWorkbook.SendMail Security Warning Michael Rekas[_2_] Excel Programming 2 December 16th 04 05:28 PM
default mail program -activeworkbook.sendmail tvc Excel Programming 2 July 7th 04 05:27 PM
Activeworkbook.sendmail Jamie[_5_] Excel Programming 2 October 2nd 03 01:25 PM


All times are GMT +1. The time now is 03:46 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"