Hyperlink in Sendobject

  • Thread starter Thread starter Chuck
  • Start date Start date
C

Chuck

I've looked through the newsgroups and still came up empty. I need to be
able to send an email with no attachments but with just a few simple lines
of text. I can do this easily. However, I need to add in a hyperlink to a
program on a harddrive. No matter how I code it, it appears as text in the
email, not as a hyperlink. I've tried adding a table with the filename as a
hyperlink, and then did a DLOOKUP to place it into the email. Same thing...
text. Any ideas? Thanks.
 
Hi Chuck,

AFAK SendObject only provides for plain text in the Message Text, so
this sounds like an issue with the way the recipient's email client
displays text that looks like hyperlinks. Have you tried specifying a
proper URL rather than just the filename, e.g. (from my computer)
instead of

C:\Documents and Settings\All Users\Documents\Answers 2002.mdb

use one of these forms:
file:///C:/Documents%20and%20Settings/All%20Users/Documents/Answers%202002.mdb
file:///C:/Documents and Settings/All Users/Application
Data/AgentStore/NewsgroupAnswers2002.mdb
 
Thanks for the reply. Here is a slim down version of what I am doing.
+++++++++++++++++++++++++++++++++++++++++++++++

Dim txtSubject, txtMessage As String
Dim ExamLink As String

ExamLink = HyperlinkPart("YAHOO!#http://www.yahoo.com#",
acDisplayedValue)
txtMessage = txtMessage & Chr(10) & Chr(10) & ExamLink
DoCmd.SendObject acSendNoObject, , , , , , txtSubject, txtMessage

++++++++++++++++++++++++++++++++++++++++++++++++

I am using Yahoo! just as an example here. If in the HyperlinkPart I use
the acDisplayedValue, the email produces YAHOO! in the email, but its not a
link. I then tried acDisplayText, same result. If I use acAddress, the
email produces the text as www.yahoo.com. The link works, but its not what
I want the recipient to see. I want something like:

ExamLink = HyperlinkPart("Click here for
exam!#file://G:\SharedData\DeptA\App\Exam.mdb#", acDisplayedValue)

Any ideas? Thanks.
 
You can't do that in plain text.

Thanks for the reply. Here is a slim down version of what I am doing.
+++++++++++++++++++++++++++++++++++++++++++++++

Dim txtSubject, txtMessage As String
Dim ExamLink As String

ExamLink = HyperlinkPart("YAHOO!#http://www.yahoo.com#",
acDisplayedValue)
txtMessage = txtMessage & Chr(10) & Chr(10) & ExamLink
DoCmd.SendObject acSendNoObject, , , , , , txtSubject, txtMessage

++++++++++++++++++++++++++++++++++++++++++++++++

I am using Yahoo! just as an example here. If in the HyperlinkPart I use
the acDisplayedValue, the email produces YAHOO! in the email, but its not a
link. I then tried acDisplayText, same result. If I use acAddress, the
email produces the text as www.yahoo.com. The link works, but its not what
I want the recipient to see. I want something like:

ExamLink = HyperlinkPart("Click here for
exam!#file://G:\SharedData\DeptA\App\Exam.mdb#", acDisplayedValue)

Any ideas? Thanks.
Click to expand...
 
Back
Top