A
Ann
I am using the function below to send email with the Subject and Message Text
automatically filled. It works as long as the Hyperlink field
(hlkDocumentation) is filled in on the form. If it's blank I get the message
"an expression you entered is the wrong datatype for one of the arguments".
However, on the ones it does fill in there are #s in front of and behind the
hyperlink and it can't be used as a hyperlink...it's like text. I'm just
learning VB so am not very good at it yet. I would appreciate any help that
can be offered. Thanks
Function EmailCSA()
On Error GoTo EmailCSA_Err
With CodeContextObject
DoCmd.SendObject , "", "", "(e-mail address removed)", "", "", .hlkDocumentation, _
"Problem logged: " & .memProblem, True, ""
End With
EmailCSA_Exit:
Exit Function
EmailCSA_Err:
MsgBox Error$
Resume EmailCSA_Exit
End Function
automatically filled. It works as long as the Hyperlink field
(hlkDocumentation) is filled in on the form. If it's blank I get the message
"an expression you entered is the wrong datatype for one of the arguments".
However, on the ones it does fill in there are #s in front of and behind the
hyperlink and it can't be used as a hyperlink...it's like text. I'm just
learning VB so am not very good at it yet. I would appreciate any help that
can be offered. Thanks
Function EmailCSA()
On Error GoTo EmailCSA_Err
With CodeContextObject
DoCmd.SendObject , "", "", "(e-mail address removed)", "", "", .hlkDocumentation, _
"Problem logged: " & .memProblem, True, ""
End With
EmailCSA_Exit:
Exit Function
EmailCSA_Err:
MsgBox Error$
Resume EmailCSA_Exit
End Function