having trouble making a hyperlink work correctly in email

[DougP]

this is the hyperlink
msg = msg & "\\servero2\Data Files\Task Order\App_Data\TaskOrder2007.mde"

But the whole thing does not show up blue only the first part up to the first space is blue.
I am using this code to create the email.

        msg = "Please see further details in database" & vbCrLf
        msg = msg & "\\servero2\Data Files\Task Order\App_Data\TaskOrder2007.mde" & vbCrLf
        msg = msg & vbCrLf
        msg = msg & "Project Number : " & Me![Project Number] & vbCrLf
        msg = msg & "Estimate Number: " & Me![EstimateNumber] & vbCrLf
        msg = msg & "Client Name: " & Me![Projects subform1]![Company] & vbCrLf
        
        DoCmd.SendObject acSendNoObject, "", actext, "hshoemaker@ohcnet.com", , , "Notification to Invoice Project # " & Me![Project Number], msg, True

I tried adding chr(34) to the string but that just added double quotes and did not make it a hyperlink at all.

TIA


DougP, MCP, A+

 

[jadams0173]

I think in HTML you need to replact the spaces with the % sign. HTH

I tried to have patience but it took to long! -DW

 

[DougP]

yes %20 is a space

\\servero2\Data%20Files\Task%20Order\App_Data\TaskOrder2007.mde

thank you

DougP, MCP, A+