Inserting a hyperlink into the body of an email

[Gina]

Hi.

I am using the following to create an email message


DoCmd.SendObject ObjectType:=acSendReport, _
ObjectName:=strReportName, outputformat:=acFormatSNP, _
To:=strEmail, Subject:=strSubject, MessageText:=strMsg

Is there an easy way to include in the Message Text a Hyperlink? The
Hyperlink will be linked to a website and the link will always be the same.

Please give me your guidance.

Gina

 

[Cheryl Fischer]

Gina,

This works for me ...

strMsg = "This is a hyperlink: http://www.mvps.org "

As you enter your message string in your VBA code, you will not see any
indication that a part of the string is a hyperlink; i.e., change of color,
underlining, etc. In testing this out, however, the sent message will
present a hyperlink.

 

[Gina]

Thank you, I will try this. That was easier than I thought.

 

[Tony Toews]

I am using the following to create an email message

As an alternative you can use Stephen Lebans RTF code to create an
HTML email thus embedding the URL "underneath" the human readable
text. And make the email fancier.

However SendObject doesn't support sending in HTML format so you'd
need to choose a different method which increases your work
considerably.

See the Access Email FAQ at my website for more info.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm