Hello,

Hope one of you Outlook/Exchange gurus can help a relative newbie.

My state gov't agency has email accounts for schools to send in reports as
.mdb files as attachments. These are "resource accounts" (don't know if
that's official MS lingo or not :) whose Inbox and Sent Items folders are
viewable by multiple real people who then deal with the reports.

I have a piece of VBA code, which I run on the newmail event in my own OL
session, that detaches any attachments from an incoming mail and plops them
in a folder (a la Eudora...).

A couple of my users have asked if we can run this code for the resource
account email addresses, as it would save them opening 50 or 60 emails a
day. However, since the bogus accounts don't ever have an Outlook session
open (at least in the normal sense) I can't figure out how I'd activate the
code.

Any ideas would be appreciated! TIA

No, VBA is a hosted language, i.e., it must run within a VBA supporting app.

Outlook need not be open, you could set up the code to run from, say, Word
or Excel, which the user may have open a lot more than Outlook.

Another alternative is to create am say, VB 6 app that runs your code via
Automation, i.e., it could silently start and close Outlook if Outlook is
not running.

Sue Mosher's  book has recently been published. I purchased a copy and it
was shipped to me yesterday. Have not yet seen the book.
Book might have the info you need. Book's ISBN is 1555582869.

--
http://www.standards.com/; Programming and support for  Word macros,
including converting from WordBasic to VBA; Technical reviewing; Standards;
Product functional/design/specifications
------------------------------------------------