importing across applications

[KODA]

Is there a way to automatically import an attachment (specifically formatted
excel file with a name beginning with PQDY-XXXXXXX) from an outlook e-mail
into a specific Access DB? Once the file is imported I want to verify content
in specific columns, can this also be done automatically?

 

[Ken Slovak - [MVP - Outlook]]

Sure, just write code to do that either from Outlook or Access, using the
Outlook object model.

See www.outlookcode.com for lots of different code samples for Outlook,
including working with attachments and working with Access.

 

[Sue Mosher [MVP-Outlook]]

Just to add to Ken's response: The first step of that operation is saving the
file from the Outlook item out to a folder using the MailItem.Attachments
collection and the Attachment.SaveAsFile method.

 

[KODA]

Thank you Sue. I was on your site yesterday, thank you for hosting this site,
it is very helpful. I have been away from VBA for about 9 yrs but getting
back into it. I'm using 2003 versions of Office but hope to upgarde to 2007
soon. Is there an advantage of using 2007 over 2003 for VBA? I will post this
there also.

 

[Sue Mosher [MVP-Outlook]]

Outlook 2007 has a much richer object model, but it offers no particular
advantage for this particular application.
--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54