Email With Link To Open Access On Network Drive

  • Thread starter Thread starter Will via AccessMonster.com
  • Start date Start date
W

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
 
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
 
Back
Top