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
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