Brian, form a post yesterday

you'll need a utility to circumvent this outlook object model protection
see: http://www.dimastr.com/redemption
keepITcool


Ron de Bruin has an approach that uses CDO rather than you mail software.
See his discussion at his site:

Ron de Bruin's site

http://www.rondebruin.nl/sendmail.htm
http://www.rondebruin.nl/index.html

an Article by Ron on MSDN:
http://msdn.microsoft.com/library/en...odc_xlmail.asp

The index should lead you there. The article is for interest although not
particularly directly appropriate.
--
Regards,
Tom Ogilvy


--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 97
** remove news from my email address to reply by email **
"Brian Walker" wrote in message
om...
Good day all..

I have written a macro that sends about 20 emals with file
attachments, Using outlook. My problem is that I have to keep clicking
yes every time it sends a file.. you know the outlook security feature
I am talking about... Any way I was using a non office program and I
got a different version of this question.

That same old message box came up,, but this time it had a new option.
It asked me how long I wanteded to allow the program to send email for
me..

Have any of you seen this? Do you know how i can use this feature in
my macro?