Email from Excel

  • Thread starter Thread starter Ed
  • Start date Start date
E

Ed

Hi

I am using a macro to automatically send a copy of a
spreadsheet using outlook but when i run this i get an
dialogue box from outlook saying

'A program is trying to automatically send mail on your
behalf

D you want to allow this?'

Is there any way of getting rid of this box as i am
sending this to many people and i dont want to keep
clicking yes?

Thanks in advance for your help.

Ed
 
I am using a macro to automatically send a copy of a
spreadsheet using outlook but when i run this i get an
dialogue box from outlook saying

'A program is trying to automatically send mail on your
behalf

D you want to allow this?'

Is there any way of getting rid of this box as i am
sending this to many people and i dont want to keep
clicking yes?
Click to expand...

Here's what I wrote earlier:
(http://groups.google.com/[email protected])

See:
OL2000: Administrator Information About the Outlook E-mail Security
Update
<http://support.microsoft.com/default.aspx?scid=kb;EN-US;263297>

There's download available from MS which will create a Public Folder
"Outlook Security Settings" with a form of the same name. It allows to
specify relaxed settings for individual users. I've used that here in
circumstances similar to yours successfully.
 
Just to add - the article states:

If you are using Microsoft Exchange Server, administrators can control the
behavior of these new features.

So if you aren't I believe the answer is no - at least not with any built in
configuration options.

Ron De Bruin offers some ways to use VBA to send the message without the
prompt using CDO (I believe). You can check out his recommendations at

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

and its subordinate pages.
 
Check out also Click Yes
http://www.rondebruin.nl/sendmail.htm#Prevent

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)




Jake Marx said:
Hi Ed,

Here's another option:

http://www.dimastr.com/redemption/

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]

Hi

I am using a macro to automatically send a copy of a
spreadsheet using outlook but when i run this i get an
dialogue box from outlook saying

'A program is trying to automatically send mail on your
behalf

D you want to allow this?'

Is there any way of getting rid of this box as i am
sending this to many people and i dont want to keep
clicking yes?

Thanks in advance for your help.

Ed
Click to expand...
Click to expand...
 
Back
Top