PDA

View Full Version : Linking Attachment from Outlook into Access



ConfusedNewb
06-28-2011, 11:40 AM
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!

JP2112
06-29-2011, 06:52 PM
Why not just save the files to a folder? Do they really need to be catalogued in Access?

Also, are they PDF files? If so, aren't they searchable via Windows Explorer?