Open form/record in Microsoft Access from Outlook

Harris@Z

Registered User.
Local time
Today, 07:49
Joined
Oct 28, 2019
Messages
113
Hi all,

Is it possible to have a link in my returned email message that when clicked, will open my Access database and open a specific form with the linked record ID?

Thanks
 
assuming it can be done, would also think the hyperlink would need to be in the outgoing message as well which would be confusing to those recipients who do receive the email. Even if marked with a 'for office use only' type message, some curious souls will click it and although it won't 'work' it will still expose some of your data to the recipient.
 
Thanks for both your responses.

I did consider that the outgoing message may be confusing, but considered possibly 'hiding' the link by making the text white, or linking to a nondescript image.

I will see if the video has any guidance.
 
A better solution is to have the Access app, read the emails several times per day and process them.
If this is better or not totally depends on the requirements. Reading the incoming emails is entirely different from providing the user a link in an email to click on to get to linked information in the Access database.

For a brief couple of years, Access had this fabulous feature embedded. But, apparently, not enough people actually used the feature so MS discontinued it.
I don't think so.
This screenshot was taken right now in the most recent Access 365 version:
1654012137481.png
 
The data collection from email feature was in Access 2007 & 2010. This is from 2010

1654030889403.png
 
IIRC I never used the EMail Data Collection feature myself. It was dropped in 2013 along with several other features
 
Thanks all for contributing to the discussion.
Sonic8 - your contribution recommending Hyperlinking or Deep Linking in Microsoft Access should have been very helpful but unfortunately the link the video supplied was to a site where the article was no longer available, and an email to the owner has not received a reply.

As the OP the rationale for my request is this:
I send an email generated by Access to a client regarding a specific order and asking for further information. I would like to embed the order number (record) and on receipt of the response, instead of searching for the order number to input the response, click on the embedded link which will automatically open an Access form already highlighting that record.
 
found this link about using a hyperlink from outlook to open access to a specific form and record. Looks like a lot of work and not necessarily resulting in a workable solution. But plenty of links to ideas
 
Thank you!

This links through to the following url: https://bytes.com/topic/access/insights/873647-invoking-database-command-line

The last post includes a zipped Access example.

Essentially the author suggests linking a variable to the end of the command line, which when the database opens, recognises the variable and acts on that variable.

e.g. "C:\Program Files (x86)\Microsoft Office\root\Office16\MSACCESS.EXE" "C:\PathtoDatabase\OpenAuto.Mdb" ;myvariable

The database opens the form "Main" which has this code On Open
If Command() = "myvariable" Then
Call MsgBox("The database is opened automatically , " & _
"and will close as soon as you click on OK", _
vbOKOnly, _
"AutoMessage")
Cancel = True
End If

Now to work out whether one can a link that runs the command line
 

Users who are viewing this thread

Back
Top Bottom