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

Status
Not open for further replies.
M

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?

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

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 Outlook

VBA Object Model. Anyone have a link to an Outlook VBA Object quick

reference?

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

Best regards

Michael Bauer

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?
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
S Autosave attachments error using Len Outlook VBA and Custom Forms 2
D Autosave Attachment and Rename Outlook VBA and Custom Forms 1
C appending 'Date Modified' to autosave script Outlook VBA and Custom Forms 19
C Outlook 2007 Autosave feature and Draft folder Using Outlook 2
J Outlook 2010 messages freeze in outbox, do not autosave, then disappear after Outlook locks up Using Outlook 7
L Outlook attachments from OneDrive as links Using Outlook 0
G Print email attachments when hit subfolder Outlook VBA and Custom Forms 1
R Saving Emails and Attachments as .msg file Using Outlook 3
KurtLass Opening Graphics Attachments in Outlook 2021 Using Outlook 0
F Outlook 2016 Email with attachments not being received Using Outlook 2
Commodore PDF attachments started to open in Edge Using Outlook 0
T Outlook 2021 Cannot open attachments Outlook DeskTop 2021 Using Outlook 0
D ISOmacro to extract active mail senders name and email, CC, Subject line, and filename of attachments and import them into premade excel spread sheet Outlook VBA and Custom Forms 2
Witzker Outlook 2019 Macro to answer a mail with attachments Outlook VBA and Custom Forms 2
P Print attachments automatically and move the mail to an existing folder called "Ted" Outlook VBA and Custom Forms 4
G Schedule recurring email and attachments display Outlook VBA and Custom Forms 3
G Save and Rename Outlook Email Attachments Outlook VBA and Custom Forms 0
L Macro/VBA to Reply All, with the original attachments Outlook VBA and Custom Forms 2
A Attachments.Delete Outlook VBA and Custom Forms 3
M Deleting attachments does not reduce file size Using Outlook 0
L unblocking attachments before sending Office 365 Advanced Protection Using Outlook 0
I Saving attachments from multiple emails and updating file name Outlook VBA and Custom Forms 0
R Use an ItemAdd to Save Attachments on Arrival Outlook VBA and Custom Forms 0
shrydvd vba to secure zip attachments Outlook VBA and Custom Forms 3
R fetching blocked attachments Outlook VBA and Custom Forms 0
H Outlook 2016 sent over 30 copies of an e-mail with attachments Using Outlook 1
W Automatically open attachments without automatically printing them Using Outlook 0
O Save attachments using hotkey without changing attributes Outlook VBA and Custom Forms 1
T Outlook converts sent email to txt attachments when sync Using Outlook 0
Nadine Rule to move attachments with specific name Outlook VBA and Custom Forms 1
R Outlook is NOT removing attachments. Using Outlook 4
Dan_W Nested email attachments Outlook VBA and Custom Forms 4
M Print email and, attachments sent in hyperlinks in the email Outlook VBA and Custom Forms 2
W Save and rename outlook email attachments to include domain name & date received Outlook VBA and Custom Forms 4
S DRAGGING MAIL AND ATTACHMENTS TO CALENDAR Using Outlook 1
D Print attachments automatically and moves the mail to a new folder Outlook VBA and Custom Forms 9
G Download pdf attachments only if email subject has one of words Outlook VBA and Custom Forms 8
D Saving Selected Emails as PDF and saving Attachments Outlook VBA and Custom Forms 6
R Quick Access view in File Explorer when saving attachments Using Outlook 0
J Save E-mail attachments in a specific folder Outlook VBA and Custom Forms 0
broadbander Needing help with reply/reply all while keeping attachments and adding a new CC recipient. Outlook VBA and Custom Forms 5
I Forwarding attachments in email received Outlook VBA and Custom Forms 3
A Outlook - Send New 20 Attachments through Email Using Outlook 4
D Print Attachments only in selected emails using a macro Outlook VBA and Custom Forms 3
M Outlook 2016 msg attachments Using Outlook 0
N Saving And Deleting Outlook Attachments with Unknown Error Message Outlook VBA and Custom Forms 1
M Macro for attachments download adjustment Outlook VBA and Custom Forms 3
M VBA macro for Inbox's attachments search Outlook VBA and Custom Forms 0
C Auto save outlook attachments when email is received Outlook VBA and Custom Forms 1
S Outlook 2010 Cannot Open Attachments Using Outlook 14

Similar threads

Back
Top