ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Outlook Security Bypass (https://www.excelbanter.com/excel-programming/390237-outlook-security-bypass.html)

naive14

Outlook Security Bypass
 
I want to have an excel VBA macro that accesses my MS Exchange email inbox,
finds certain emails based on sender/subject, moves the emails to another
folder, and detaches and processes any attached files.

Due to security with Outlook (get a warning message "...external application
attempting to access address book...") I had to use Ron DeBruin's solution
of splitting the work by having an Outlook rule to filter and move the
correct emails and then the VBA code to detach and process the files.
Unfortunately this means that I have to keep Outlook open on my PC as rules
are part of the client execution. This is unacceptable.

Is there any way to bypass this security warning or Outlook althogether ???

Both Excel and Outlook are 2002 SP3.

thanks.


Bob Phillips

Outlook Security Bypass
 
http://www.dimastr.com/redemption/

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"naive14" wrote in message
...
I want to have an excel VBA macro that accesses my MS Exchange email inbox,
finds certain emails based on sender/subject, moves the emails to another
folder, and detaches and processes any attached files.

Due to security with Outlook (get a warning message "...external
application
attempting to access address book...") I had to use Ron DeBruin's solution
of splitting the work by having an Outlook rule to filter and move the
correct emails and then the VBA code to detach and process the files.
Unfortunately this means that I have to keep Outlook open on my PC as
rules
are part of the client execution. This is unacceptable.

Is there any way to bypass this security warning or Outlook althogether
???

Both Excel and Outlook are 2002 SP3.

thanks.




naive14

Outlook Security Bypass
 
Thank you. I haven't tried this yet but I'm sure it will work.



"Bob Phillips" wrote:

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

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"naive14" wrote in message
...
I want to have an excel VBA macro that accesses my MS Exchange email inbox,
finds certain emails based on sender/subject, moves the emails to another
folder, and detaches and processes any attached files.

Due to security with Outlook (get a warning message "...external
application
attempting to access address book...") I had to use Ron DeBruin's solution
of splitting the work by having an Outlook rule to filter and move the
correct emails and then the VBA code to detach and process the files.
Unfortunately this means that I have to keep Outlook open on my PC as
rules
are part of the client execution. This is unacceptable.

Is there any way to bypass this security warning or Outlook althogether
???

Both Excel and Outlook are 2002 SP3.

thanks.






All times are GMT +1. The time now is 01:46 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com