I am trying to have an email created from Access which has a hyperlink in the body of the message. The code I have now is working fine and the hyperlink is fine. What I want to do is change the hyperlink to a display name/word
I am currently using the docmd.sendobject with the following syntax...
DoCmd.SendObject , , acFormatHTML, [EmailAddress], , , "Request pricing for new product", "Dear consumer," & Chr(10) & Chr(10) & "The product you requested can be found on the website:" & Chr(10) & Chr(10) & "http://www.computraksystem.com/componentsdetail.asp?procode=
" & Me![ProductDatabaseList]
So... Instead of showing http://www.computraksystem.com/componentsdetail.asp?procode=1
in the body of the email, I would like it to show something like "Click Here"