![]() |
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. |
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. |
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