I need a Hyperlink to show in an email using Access

[DougP]

I having trouble creating a Hyperlink in and email using VBA in Access
The hyperlink shows up partially ending at the space
\\servero2\Data[color] Files\Task Order\TimeSheets.mdb
Here is my code

    Dim Msg As String
    Msg = "Please open your timesheet and fill it out!" & vbCrLf
    Msg = Chr(34) & "\\servero2\Data Files\Task Order\TimeSheets.mdb" & Chr(34) & vbCrLf
    Msg = Msg & vbCrLf    ' Blank Line
    Msg = Msg & "OHC Environmental Droid" & vbCrLf
    Msg = Msg & "Timsheet Administrator" & vbCrLf
    
    DoCmd.SendObject acSendNoObject, "", acFormatHTML, , , , "Missing Timehseet info for " & Me.WeekEndDate, Msg, True

TIA



DougP

 

[SkipVought]

Hi,

Try this. It works MANUALLY to create a hyperlink where there are SPACES...

    Msg = "<\\servero2\Data Files\Task Order\TimeSheets.mdb>" & vbCrLf

Skip,

_{Have you heard that the roundest knight at King Arthur's round table was...
Sir Cumference!}

 

[PHV]

Another way you may try:
Msg = Replace("\\servero2\Data Files\Task Order\TimeSheets.mdb", " ", "%20")

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886