Hyperlink code in the vba codes

[aattas]

Experts,
I am able to create an auto email to send to people and of course it has the
.subject =" Project 123"
.body = " This is a warning email for more information, click the subject"

My question is :
Is there anyway that I can do the hyperlink on the text "Project 123" to transfer to the main form for the person to update when the person receives the message in his email?

Thank you

 

[Ranman256]

you would need some COMMAND line code to activate Access with a parameter.
call access, with the DB, and the key to goto.
i.e:
c:\program files\Access.exe "c:\folder\database.accdb" / cmd "Project123"

the command code would open the form to that key.
or
are you wanting to open a website?

 

[Ranman256]

like:

Public Sub CheckCommandLine()
    ' Check the value returned by Command function and display
    ' the appropriate form.
    If Command = "Orders" Then
        DoCmd.OpenForm "Orders"
    ElseIf Command = "Employees" Then
        DoCmd.OpenForm "Employees"
    Else
        Exit Sub
    End If
End Sub