Outlook attachments 1

[bpurser]

I receive 8-10 emails a day from 6 or so people. Each has from one to five attachments. In theory, I'm supposed to review these attachments, but frankly I don't have time, so what I've been doing is saving them to various network directories for the day when either I do have time or can hand them off to someone else.

What I'd like to do is have some VBA code read through my inbox, find the email from Joe Blow, grab the attachment, and save it to H:\MyStuff\reports\JoeBlow\, then delete the message, find the message from Sue Smith, grab the attachment, and save it (altering the filename to include yesterday's date) to another directory...

Each message from Joe is going to be saved to the same directory, each message from Sue also saved to the same (different than Joe's) directory.

I can send emails via outlook from Access,and create calendar appointments, but search as I might, I can't find either some sample code or a worthwhile description of the Outlook object model to know how to refer to sender name, attachments, save as, etc....anybody out there point me in the right direction?

Many thanks--

Ben

 

[vbajock]

Scott Barker's Microsoft Access 2000 Power Programming has an excellent section on using the Outlook OM in Access and a great CD with Outlook object model code templates. You can find it on Amazon.

 

[SteveR77]

Vbajock,


Thanks. I could not remember who the author of this was but could recall seeing a book on it a month or so ago.


Steve

 

[vbajock]

The CD is worth the price of the book. You can literally cut and paste a whole Access/Outlook app out of the frags he has in there. Let me know if you need anymore help, I write automated email apps for a living.

 

[bpurser]

Thanks--I will check it out...

 

[Quehay]

I 2nd the recommendation! It's an excellent book, and I frequently refer to it and cite it here.

Jeffrey R. Roberts
Insight Data Consulting
Access, SQL Server, & Oracle Development

http://www.InsightDataConsulting.com