give one of these a try
Sending Snapshot format
DoCmd.SendObject acReport, "ReportNameHere", _
"SnapshotFormat*.snp)", "ToMailRecipient", _
"CcMailRecipient", "BccMailRecipient", _
"Subject Line", "MessageTextLineHere Example:Click on this line - \\PathSrvr\Users\ObjectName.htm", False, ""
Sending Rtf format
DoCmd.SendObject acReport, "ReportNameHere", _
"RichTextFormat*.rtf)", "ToMailRecipient", _"CcMailRecipient", "BccMailRecipient", _
"Subject Line", "MessageTextLineHere Example:Click on this line - \\PathSrvr\Users\ObjectName.htm", False, ""
Sending without an attached report
DoCmd.SendObject , "", "SnapshotFormat*.snp)", _
"ToMailRecipient", "CcMailRecipient", _"BccMailRecipient", "Subjectline", "MessageTextLineHere Example:Click on this line - \\PathSrvr\Users\ObjectName.htm", False, ""
I don't understand what your problem is. You should be able to insert a hyperlink in an Email body of almost any Email client merely by inserting the text of the hyperlink (I'm not aware of any exceptions). I've been doing that quite a bit recently.
embedded in a message would go to tek-tips.
----------------------
scking@arinc.com
Life is filled with lessons.
We are responsible for the
results of the quizzes.
-----------------------
I want to link to another access program on the network. I just can't seem to find the right setup. I'm using a docmd.sendobject something like this DoCmd.SendObject ,,, [struser],,,, [strMessage], False, ""
My strMessage is a string value. Which is rather long. Do i just put the hyperlink behing my orginial message? Ex. This would be my message "\\this would be my hyperlink".
Where you put it is of no consequence. Just make sure it is constructed properly and separated by a space from any other text.
----------------------
scking@arinc.com
Life is filled with lessons.
We are responsible for the
results of the quizzes.
-----------------------
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.