Re: manage attachments

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_samp...tripAttachments

--
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" <JFreed@discussions.microsoft.com> wrote in message news:0C3FF20B-92EF-47E2-ACD0-2DC1FC0C46AD@microsoft.com...
> 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...

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" <JFreed@discussions.microsoft.com> wrote in message news:0E3B682D-9B46-4F8A-B0F0-2DB52C2E909D@microsoft.com...
> 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_samp...tripAttachments

>>
>> "J. Freed" <JFreed@discussions.microsoft.com> wrote in message news:0C3FF20B-92EF-47E2-ACD0-2DC1FC0C46AD@microsoft.com...
>> > 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...
>>

We can't look over your shoulder and know what you've tried or where it failed. If you want assistance with your ADO code, provide some details please.

--
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" <JFreed@discussions.microsoft.com> wrote in message news:EC422A9C-F891-4CDF-A2AD-B8B0849BA960@microsoft.com...
> 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
>>
>> "J. Freed" <JFreed@discussions.microsoft.com> wrote in message news:0E3B682D-9B46-4F8A-B0F0-2DB52C2E909D@microsoft.com...
>> > 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_samp...tripAttachments
>>
>> >>
>> >> "J. Freed" <JFreed@discussions.microsoft.com> wrote in message news:0C3FF20B-92EF-47E2-ACD0-2DC1FC0C46AD@microsoft.com...
>> >> > 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...
>> >>
>>