|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Search this Thread | Display Modes |
|
|
|
#1
December 20th 06, 05:47 PM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
manage attachments
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... 
|
|
#2
December 20th 06, 06:00 PM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
|
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_sampl...ripAttachments -- 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 ... 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...
|
|
#3
December 20th 06, 07:45 PM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
|
manage attachments
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 -- 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 ... 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...
|
|
#4
December 20th 06, 08:12 PM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
|
manage attachments
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...
|
|
#5
December 21st 06, 04:16 PM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
|
manage attachments
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...
|
|
#6
December 21st 06, 04:22 PM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
|
manage attachments
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" wrote in message ... 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" 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...
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Manage Massage Rules | Woofer Din | Outlook Express | 1 | November 14th 06 07:54 PM |
| how do I manage the agenda of my team? | stphncr | Outlook - Calandaring | 1 | July 15th 06 06:59 PM |
| I want to be able to manage Outlook ANYWHERE! | Rochelle | Outlook - General Queries | 9 | June 29th 06 04:48 PM |
| Manage Identities and PAB | JD | Outlook Express | 12 | June 19th 06 01:14 PM |
| manage outlook through gpo | Guillermo G. Lovato | Outlook - General Queries | 4 | March 15th 06 05:16 PM |
Hybrid Mode
