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.

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.

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.