Question Downloading attachments from MS Office Outlook 2007

[mcdhappy80]

I've read that one can integrate Access and Outlook to manipulate e-mails in some way. What I need to do is to open Outlook 2007 form Access 2007, see if there are new mails for the day, open one specific mail, download its attachment and store it somewhere on hdd. Is this possible to do with VBA? Can someone post code examples please?
Thank You.

 

[ajetrumpet]

yes it's possible, but it is very time consuming to write. You need to look into the outlook objects by yourself if noone gives you the code. go into outlook and get some of the objects you can by looking at the intellisense options.

also, to get part of the code you need, at least for the declarations, see my faq called SEND EMAILS WITH OUTLOOK