Opening Outlook 2000 attahments with Access 2000

[David]

Is it possible to open outlook/exchange attachments with
MS Access?? I have created a link table to a mailbox which
displays all text data, but cannot figure out how to link
the mailbox attachments? searched for hours for a similar
post? has anyone experienced the same dilema??

 

[John Nurick]

Hi David,

AFAIK you'll need to write VBA code using Automation to manipulate
messages in the mailbox folders and retrieve the attachments, probably
using the CDO (collaboration data objects) library. You'll find
information at http://www.slipstick.com and in Tony Toews's email FAQ at
http://www.granite.ab.ca/accsmstr.htm