importing across applications

  • Thread starter Thread starter KODA
  • Start date Start date
K

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?
 
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.
 
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.
 
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.
 
Back
Top