Downloading Outlook Attachments

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I am pretty proficient working with Access VBA but the following I have no
idea how to do, & I would think this is possible.

I would like to know if an Email is recieved & it has attachments to
programtically have the attachments downloaded. Ideally also not just any
Email but just certain ones based on what is is the "Subject"
For Example if subject has "Daily Files" then only attachments of those
Emails get downloaded.

Can this be done in Access ? If so what would be the code to do so ?

Any help would be greatly appreciated.

Thank you,
Jeff
 
Hi Jeff,
Can this be done in Access ? If so what would be the code to do so ?
Click to expand...

Yes it can be done in Access, but more importantly, the answer is
familiarity with the different object model offered by the different Office
applications (i.e. Access, Outlook, Word, Excel).

VBA is the common language you, as the programmer, use to manipulate the
various different object models. So, if you need to manipulate Outlook
objects (as evident by your question), you would need to understand the
Outlook object model. You would find more help in the Outlook newsgroup.


HTH,
Immanuel Sibero
 
Hi Immanuel, thank u for the response.

I have found some code to insert as an Outlook Module that will work. Do
you know of a way to run the Modle from within Access ?

Thank you,
Jeff
 
Hi Jeff,

Tony Toews has good information on using Outlook from Access:
http://www.granite.ab.ca/access/email.htm

I have found some code to insert as an Outlook Module that will work. Do
you know of a way to run the Modle from within Access ?
Click to expand...

I'm not sure I understand your question clearly here.
You can execute that Outlook Module in Access the same way you execute any
other VBA module or any Access module. When you say "Outlook Module", you
are refering to VBA code, arent you? You can run it by (among other ways):
- calling it from a procedure
- code behind a command button, forms.
- event handlers
- etc. etc.

HTH,
Immanuel Sibero
 
Back
Top