Setting up a Link to an attachment in Outlook

[sstump]

OK here's the scoop. I receive emails daily with attached spreadsheets for reporting of an outside vendor.

I know how to create a link from Access to Outlook and store email information. However is there a way to do just that but also extract the attachments to a table/tables?

Can that be done? Not so great with VB, so hopefully if it's possible I can figure it out. It would make my life much easier.

 

[danvlas]

Attachments? They are actually various files (doc, xls, dat, exe, zip and so on)

You would need to use Automation, create an instance of Outlook, create and inspect an olMailItem in folder Inbox - or whatever - and its Attachments collection, then save the attachments to a known location under a known name, then store the path in the database.

Unless you want to embed it in the db, which is highly unrecommendable (for Access) because it would create an unnecessary overhead on the system...

Don't rely too much on the wizards - they're designed for very basic stuff.

HTH





Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html

 

[sstump]

Yes they are all *.xls files.

I'm thinking this might be way over my head.

Basically what I'm looking to do is have the DBase pull these files in daily and then build the forms and queries so that others can pull the stats from them in daily/weekly/monthly. However I'm trying to make the initial daily processing of these fairly low maintenance.

Gonna have to dust off my VBA book and try to make sense of them I guess.

 

[sstump]

Yes it's always a *.xls file.

Either way I think this is going to be way over my head. I'll do some searching around and see what I can find.

 

[sstump]

Well I ran across a handy Outlook Add-in tool (using Demo for first 30 days) that allows you to tell it what outlook folders to look in and it will output the attachments to a specified folder/file for you. Plus it has a built in Scheduler, so I can specify time and days or I can have it check every few hours. If anyone is looking for how to do this check out MAPILab...it's $25 after the demo runs out.

I'm never gonna learn VB if I keep running across handy tools to do the job for me.