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


--
Mr. Walnuts

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:

> I should start by saying that I have never used VBA for Outlook. I can
> use basic Outlook Functions; mail rules, data files, etc.
>
> I -do- however have experience using Macros & VBA for Excel
> 2003/2007/2010.
>
> I'm making an excel application to automate as much of a friend of
> mine's administrative tasks as possible for his work. Does anyone know
> whether or not you can make a macro on Outlook or Excel to retrieve
> email attachments from Outlook, file the attachments in a specified
> location on his computer based on Outlook rules, and add the
> attachment name to a database on Excel so that the attachments can be
> referenced and opened from an excel worksheet that lists the
> attachments?
>
> I realize this is an Outlook forum, so really if someone could give me
> insight on how to get the Outlook part of it (Autosaving Email
> Attachments based on specified criteria to a folder on the computer); I
> can setup the Excel side myself.
>
> Also, does anyone know of any decent online tutorials about Using
> Outlook and Excel together to automate tasks?

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


--
Mr. Walnuts

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:

> Outstanding... Thank you.
>
> Thats exactly what I needed. I just was not familiar with the Outlook
> VBA Object Model. Anyone have a link to an Outlook VBA Object quick
> reference?