Thanks, that worked out well. The next step.. and after this I think I can
handle it on my own... is to open the Access DB I've created from within the
Outlook macro. I've tried a few of the ADO approaches in here and none of
them seem to work. Thanks!

"Sue Mosher [MVP-Outlook]" wrote:

These pages show several different ways to process incoming messages:

http://www.outlookcode.com/codedetail.aspx?id=1410
http://www.outlookcode.com/d/code/zaphtml.htm

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"J. Freed" wrote in message ...
Thanks. This is an excellent start. Question: how would I set up the macro to
run on incoming messages only? The idea being that the macro would run on a
new message, collect the sender and file name, compare it against an Access
table and send the file to the destination in the table.

"Sue Mosher [MVP-Outlook]" wrote:

These samples show various ways to save attachments:

http://www.fontstuff.com/outlook/oltut01.htm
http://www.outlookcode.com/codedetail.aspx?id=70
http://www.slovaktech.com/code_sampl...ripAttachments


"J. Freed" wrote in message ...
I'm not sure if this has been addressed here, but this is what I'm looking
for---

I work with a group that gets a lot of attachments, mostly spreadsheets. The
spreadsheets have to be detached and saved into specific locations so that
they can be examined/used in other applications. What I'd like is a tool that
will allow me to automatically manage attachments as they come into a user's
Inbox; specifically, I'd like the ability to set up rules so that "if filea
arrives from senderb, place the file in locationc" and make it accessible
(possibly in an Access DB) so users can manage it.

I'm looking at 3rd party products but if I can make it myself in VBA that'd
be even better. TIA...