open outlook saved email from access

My user is saving emails from outlook and putting the location and name into a Microsoft sql database. They want to have a tool created in access that will open the saved file when needed.  Is there a way to do this?
LVL 1
kw66722Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jeffrey CoachmanMIS LiasonCommented:
With no details on how this is being done., ..it is difficult to say...
Saving emails how exactly?
If the emails are in Outlook originally, ...what the need to "save" them anywhere else?
0
Ryan ChongCommented:
can you show as sample data what was saved in MS SQL and how you want to do this in Access? is the data in MS SQL was linked/ imported into Access? Do you need an interface to open the saved file? where and how those files are being saved?
0
kw66722Author Commented:
1. saving the email to a server.
2. taking the location and name of file and saving that in a nvchar field in  the database
For example: "C:\user\xx\zzzz.msg"
3. in Access opening the email when a person clicks on the field

Unless there is a better way to do this.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Ryan ChongCommented:
ok, so at the end, you need the part of a Click event in Access to launch a .msg file?
1
Jeffrey CoachmanMIS LiasonCommented:
Still confused...
In a typical environment, Emails are stored on an Exchange "Server", ...so I still don't see a need to store the emails a second time...

It is still not clear exactly how you are doing this...
0
kw66722Author Commented:
A click event in access would work. Is that possible?
0
Ryan ChongCommented:
do you think you could reply to Jeffrey on his comment at: ID: 41067564 ?

we try to understand your issue with further details
0
kw66722Author Commented:
I discovered the hyperlink and was able to open the file. The reason I was storing it at a separate location is because there is no other way for me to link to the email from the sql table. The other fields in the table are relevant for the stored email.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Jeffrey CoachmanMIS LiasonCommented:
...oh, ...you never mentioned external SQL tables or fields...

Glad you got it working, ...you can now accept your own post as the solution
0
kw66722Author Commented:
I figured it out on my own.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.