attempt access e-mail addresses stored in outlook from Excel macro

A

ashthebash

I have an excel macro that generates a few files and then sends them to
relveant addresses from my outlook. Following the recent upgarde from office
2000 to office 2003 I get 2 frustrating but worthwhile messages. The messages
are worthwhile if they where generated by an external macro but there are
being generated from the macro I created. the 2 are aas follows:
1) "A program is trying to access e-mail addresses you have stored in
outlook" do you want to allow this? ". I would like this to be set to use
when running the macro.
2)"A programm is trying to automatically send e-mail on your behalf. Do you
want this?" Again I would like this automatically set to yes during the
running of the macro.

I understand that this is a security measure that is much needed seeing all
the problems that are generated by viruses and the rest but in this situation
the macro is valid. The main problem is there are 30 mails to be sent each
day and it does get rather annoying to have to wait 5 seconds to clin on yes.

Anybody offer some advice?
 
M

Milly Staples [MVP - Outlook]

Have you tried this?

http://www.contextmagic.com/express-clickyes/


--
Milly Staples [MVP - Outlook]

Post all replies to the group to keep the discussion intact. All
unsolicited mail sent to my personal account will be deleted without
reading.

After furious head scratching, ashthebash asked:

| I have an excel macro that generates a few files and then sends them
| to relveant addresses from my outlook. Following the recent upgarde
| from office 2000 to office 2003 I get 2 frustrating but worthwhile
| messages. The messages are worthwhile if they where generated by an
| external macro but there are being generated from the macro I
| created. the 2 are aas follows: 1) "A program is trying to access
| e-mail addresses you have stored in outlook" do you want to allow
| this? ". I would like this to be set to use when running the macro.
| 2)"A programm is trying to automatically send e-mail on your behalf.
| Do you want this?" Again I would like this automatically set to yes
| during the running of the macro.
|
| I understand that this is a security measure that is much needed
| seeing all the problems that are generated by viruses and the rest
| but in this situation the macro is valid. The main problem is there
| are 30 mails to be sent each day and it does get rather annoying to
| have to wait 5 seconds to clin on yes.
|
| Anybody offer some advice?
 
Top