link database to email attachments

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have been tasked to automatically link an Access database to a text
delimited attachment that I receive in my inbox every 2 hours. The .txt file
has the same name each time it's delivered, and it comes from the same email
address each time.

What methods can I use to link to this attached file? Would there be any VB
coding involved? Is there a URL that could walk me through the steps?

Thanks!
 
Do you mean that you want to update the database with the information in the
attachment as it arrives? "Link" doesn't seem to be appropriate in this
scenario.
 
Yes, updating.

Sue Mosher said:
Do you mean that you want to update the database with the information in the
attachment as it arrives? "Link" doesn't seem to be appropriate in this
scenario.

--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
Click to expand...
 
Outlook version? That will determine whether you can do this as a rule
procedure or need to also write an event handler.

To work with the attachment, you'll save it to the file system with the
Attachment.SaveAsFile command. You can look up more about it in Outlook VBA
Help.

In the meantime, see http://www.outlookcode.com/d/database.htm for basics on
working with databases from Outlook.

--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
 
It's Outlook 2003. I believe that it's version 11 (long version is
11.5608.5703).
thanks for the link. I'm looking at it right now.
 
Back
Top