Solved

HTML to link

Posted on 2013-01-29
2
253 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

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Query to summarise data Like Pivot Table 3 29
Error in Rs.MoveNext & Duplication of Record 14 25
Sub Reports 8 22
Continuous form : Prefilled Data 7 15
Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
Familiarize people with the process of utilizing SQL Server stored procedures 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 Micr…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …

920 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now