Email Workbook
 

Hi:

I'm using the following code to email a workbook

ActiveWorkbook.SendMail ", "Message Subject", Null

It works fine but I get this Outlook message saying a program is tryin
to automatically send emails. The message seems to be on a timer 'cuas
the OK button is greyed out until the progress bar is completed.

Is there a way to bypass this message? Or maybe shorten the time an
using code click OK on the msg box?

thank

--
halem
-----------------------------------------------------------------------
halem2's Profile: http://www.excelforum.com/member.php...nfo&userid=993
View this thread: http://www.excelforum.com/showthread.php?threadid=27114

Email Workbook
 

hi,
not sure but check out this site
http://www.rondebruin.nl/sendmail.htm
he know a lot about seeding emails. you might find
something there to help you
regards Frank

-----Original Message-----

Hi:

I'm using the following code to email a workbook

ActiveWorkbook.SendMail ", "Message
Subject", Null

It works fine but I get this Outlook message saying a
program is trying
to automatically send emails. The message seems to be on
a timer 'cuase
the OK button is greyed out until the progress bar is
completed.

Is there a way to bypass this message? Or maybe shorten
the time and
using code click OK on the msg box?

thanks


--
halem2
----------------------------------------------------------
--------------
halem2's Profile: http://www.excelforum.com/member.php?
action=getinfo&userid=9930
View this thread:
http://www.excelforum.com/showthread...hreadid=271149

.

Email Workbook
 

Look here
http://www.rondebruin.nl/mail/prevent.htm

--
Regards Ron de Bruin
http://www.rondebruin.nl


"halem2" wrote in message ...

Hi:

I'm using the following code to email a workbook

ActiveWorkbook.SendMail ", "Message Subject", Null

It works fine but I get this Outlook message saying a program is trying
to automatically send emails. The message seems to be on a timer 'cuase
the OK button is greyed out until the progress bar is completed.

Is there a way to bypass this message? Or maybe shorten the time and
using code click OK on the msg box?

thanks


--
halem2
------------------------------------------------------------------------
halem2's Profile: http://www.excelforum.com/member.php...fo&userid=9930
View this thread: http://www.excelforum.com/showthread...hreadid=271149