Alert message during Activeworkbook.sendmail

[N10]

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 Recipients:[email protected], 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 Thomlinson]

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]

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

Jim

Thanks for the reply

Im going to follow the link and see what I can learn.

Best N10

 

[N10]

Hi Jim

Many thanks for the link...problem sloved

Best N10