Solved

HTML to link

Posted on 2013-01-29
2
257 Views
Last Modified: 2013-01-29
I have the following HTML code that sends an email from access through Outlook. How can I make the "Me.[LinktoBio]" a live link? The data is always in the form www.Bioslink.com.

& "<P> Your swim coach will be " & Me.[Instructor] & " who is an awesome swim instructor. You can find a short bio of " & Me.[Instructor] & " at " & Me.[LinktoBio] & ".</P>" _

Any help you can provide would be great!
0
Comment
Question by:cansevin
2 Comments
 
LVL 12

Accepted Solution

by:
Jeff Darling earned 500 total points
ID: 38832756
I think you want to use href around the Me.[LinktoBio]

like this

"<P> Your swim coach will be " & Me.[Instructor] & " who is an awesome swim instructor. You can find a short bio of " & Me.[Instructor] & " at <a href=" & chr(34) & Me.[LinktoBio] & chr(34) & ">" & Me.[LinktoBio] & "</a>.</P>"

Open in new window


notice that the Me.[LinktoBio] is shown twice.

see this link for more info about href.

http://www.w3schools.com/html/tryit.asp?filename=tryhtml_links
0
 

Author Closing Comment

by:cansevin
ID: 38832858
Wow... nice work, works perfect. Thanks!
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

679 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question