Pulling an attachment from Outlook to Access

[ConfusedNewb]

Hey all you geniuses out there, this is a cry for help! I was tasked with creating a way to have all scanned documents sent via email to be stored and searchable. All this because my manager thought it would be "neat". :banghead: In case you are wondering, i have ZERO computer programming skills; I am a patient advocate for charity. I was able to search the internet some and cobbled together some VBA code that will identify the specific emails (using Scan in the subject line to separate the emails documents from other emails). I am attempting to use MS Access for the sorting/storage of the files. I have been unable to find a way to create a link and/or hyperlink from the incoming email into the Access database. Anyone out there able to help me out with some code, tips, or alternate theories? Thanks!

[HiTechCoach]

See if this example I created helps: Document Links 2 (http://www.hitechcoach.com/index.php?option=com_docman&task=doc_details&gid=14&Itemid=28)

Boyd Trimmell aka HiTechCoach (http://www.hitechcoach.com/)
Microsoft MVP - Access Expert




(http://www.hitechcoach.com/index.php?option=com_docman&task=doc_details&gid=14&Itemid=28)

[ConfusedNewb]

I downloaded your example, but I am not sure how to make it "work". What do I need to type in the field boxes?

[HiTechCoach]

I downloaded your example, but I am not sure how to make it "work". What do I need to type in the field boxes?

The date will default. You use the command button to select the file. The only text box you really need to enter data into manually will be the file description. This will help you identify the file.

[guoting]

I don't know what you want to do???????