How to AutoSave Attachments that meet a criteria to a folder on a local drive

[Mr. Walnuts]

I should start by saying that I have never used VBA for Outlook. I ca
use basic Outlook Functions; mail rules, data files, etc.

I -do- however have experience using Macros & VBA for Exce
2003/2007/2010.

I'm making an excel application to automate as much of a friend o
mine's administrative tasks as possible for his work. Does anyone kno
whether or not you can make a macro on Outlook or Excel to retriev
email attachments from Outlook, file the attachments in a specifie
location on his computer based on Outlook rules, and add th
attachment name to a database on Excel so that the attachments can b
referenced and opened from an excel worksheet that lists th
attachments?

I realize this is an Outlook forum, so really if someone could give m
insight on how to get the Outlook part of it (Autosaving Emai
Attachments based on specified criteria to a folder on the computer);
can setup the Excel side myself.

Also, does anyone know of any decent online tutorials about Usin
Outlook and Excel together to automate tasks

 

[Michael Bauer [MVP - Outlook]]

If you want to run the code by a rule, use a Run-a-Script-Rule, for which
the declaration looks like this:

Public Sub WhatEver(Mail as Outlook.MailItem)
' your code
End Sub

In that procedure you can check the Mail.Attachments collection for whether
there's at least one attachment. Also, see the Attachment.SaveAsFile
function.

--
Best regards
Michael Bauer - MVP Outlook
Category Manager - Manage and share your categories:
SAM - The Sending Account Manager:
<http://www.vboffice.net/product.html?lang=en>


Am Thu, 29 Apr 2010 03:17:53 +0100 schrieb Mr. Walnuts:

 

[Mr. Walnuts]

Outstanding... Thank you.

Thats exactly what I needed. I just was not familiar with the Outloo
VBA Object Model. Anyone have a link to an Outlook VBA Object quic
reference

 

[Michael Bauer [MVP - Outlook]]

See the object browser (f2), and switch from <All Libraries> to Outlook.

--
Best regards
Michael Bauer - MVP Outlook
Category Manager - Manage and share your categories:
SAM - The Sending Account Manager:
<http://www.vboffice.net/product.html?lang=en>


Am Mon, 3 May 2010 02:58:36 +0100 schrieb Mr. Walnuts: