Newbie- is this possible? (code to save attachments from server to network drive, without opening em

[ker_01]

I have an internal customer who is getting data reports created and emailed
to him automatically. He has to make those available to me (and others) as
part of a current project. He set up his outlook so that any reports that
meet the subject line criteria are automatically sent to the whole team,
which wastes bandwidth, and I don't know if that forwarding works all the
time, or only when his machine is on.

Ideally, I'd like to set up his account so that the two attachments (always
with the same name) are instead downloaded to a shared area. It is highly
desirable for this to happen even if his PC is not on (perhaps he's on a
business trip or on vacation), but worst case would be still to at least
have them download instead of being forwarded.

Can anyone point me in the right direction? I'm pretty capable with the
Excel object model, but have almost no real experience with the Outlook
model.

Thanks,
Keith

 

[GP]

The logical solution would be to set up a shared mailbox on your mail server
to which the whole team has access, and arrange for the automatic e-mails to
be addressed to the shared mailbox and not to a personal e-mail account. Then
the whole team can get what they need anytime. You can prevent others having
access to the shared mailbox using user-groups and permissions.

G

 

[ker_01]

That sounds like a great way to ensure group access to the email.

My ultimate goal is to have the files automatically detach without requiring
user intervention, and without requiring a user to open that mailbox or have
their PC turned on. Once those files are automatically detaching to the
network drive from the Outlook server, then our other program can grab those
files and process them automagically.

My work with Excel VBA has all been "local" (code runs on the local
machine). Is this also true of Outlook? For example, if I want the
attachments to be detached to the network drive, would I need to put that
Outlook code on every user's PC and even then the files would still only be
transferred once someone opens Outlook so the code could run? If that's the
case, I probably need to go back to the folks emailing the files and work
out a non-email solution.

Thanks,
Keith

 

[GP]

VBA is a macro language for applications, in other works an application that
supports VBA needs to be running (typically Word, Excel, Outlook, etc). You
can't run a client side VBA macro if the PC is turned off. Even with a shared
mailbox, at least one user with access to the mailbox needs be be logged on
to run a VBA macro. I'm sure other programming languages can get arund this,
e.g. VB2005 or VB2008, but they are not my forte I'm afraid.

GP