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

  • Thread starter Thread starter Mr. Walnuts
  • Start date Start date
M

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
 
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:
 
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
 
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:
 
Back
Top