Thread: Email Workbook
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
halem2[_47_] halem2[_47_] is offline
external usenet poster
 
Posts: 1
Default 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