Email With Link To Open Access On Network Drive

[Will via AccessMonster.com]

I have a routine that emails a person when an issue is assigned to them.

Is there a way to include "in the body of the email" a link to open the
Access database on the network?

Below is my code. It makes the link clickable, but it just brings up a
browse for the file box:


Private Sub Submit_KeyPress(KeyAscii As Integer)
If (IsNull([JobOrder])) Then
' If no Job Order selected, stop procedure
MsgBox "You Must Enter A Job Order#"
Exit Sub
Else
If (IsNull([CustomerNo])) Then
' If no Job Order selected, stop procedure
MsgBox "You Must Enter A Customer Number"
Exit Sub
Else
' DoCmd.SendObject acSendNoObject, , , Me.AssignedTo.Column(1), , , "
Issue Tracking No: " & Me.TrackingNo & "", "YOU HAVE AN ISSUE TO RESOLVE.
Assigned Date: " & Me.AssignedDate & "<\\N:\Reports\Technology\Access
Databases\Issue Tool\Tools.mdb>"""""

DoCmd.GoToRecord , , acNewRec
End If
End If

End Sub



Thanks,

Will

 

[MacDermott]

The third argument of the DoCmd.SendObject command lets you specify
acFormatHTML
as your output format. You can then include the HTML for a link around your
network address in the Message argument. I think it should go something
like this:
<a href="\\N:\Reports\Technology\Access Databases\Issue Tool\Tools.mdb">
\\N:\Reports\Technology\Access Databases\Issue Tool\Tools.mdb </a>

HTH