Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to email 1 sheet in a workbook? | New Users to Excel | |||
Email a worksheet vs workbook | Excel Discussion (Misc queries) | |||
HOW TO PUT MORE THAN ONE WORKBOOK ATTACHMENT IN AN EMAIL? | Excel Discussion (Misc queries) | |||
how to email one sheet only of a workbook | Excel Discussion (Misc queries) | |||
Email Workbook | Excel Programming |