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.

--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Professional Programming Outlook 2007.
Reminder Manager, Extended Reminders, Attachment Options.
http://www.slovaktech.com/products.htm


"KODA" wrote in message
...
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?

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.
--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54




"KODA" wrote:

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?

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]" wrote:

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.
--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54




"KODA" wrote:

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?

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




"KODA" wrote:

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]" wrote:

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" wrote:

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?