Inserting a hyperlink into the body of an email

  • Thread starter Thread starter Gina
  • Start date Start date
G

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
 
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 said:
I am using the following to create an email message
Click to expand...

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
 
Back
Top