asked on

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?

Jeffrey Coachman

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?

Ryan Chong

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?

kw66722

ASKER

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.

Ryan Chong

ok, so at the end, you need the part of a Click event in Access to launch a .msg file?

Jeffrey Coachman

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...

kw66722

ASKER

A click event in access would work. Is that possible?

Ryan Chong

do you think you could reply to Jeffrey on his comment at: ID: 41067564 ?

we try to understand your issue with further details

ASKER CERTIFIED SOLUTION

kw66722

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Jeffrey Coachman

...oh, ...you never mentioned external SQL tables or fields...

Glad you got it working, ...you can now accept your own post as the solution

kw66722

ASKER

I figured it out on my own.