How to change http:// to mailto: in hyperlink
I was trying to fix the problem of the hyperlink issue, changing it from http:// to mailto: if you want to send email by outlook do the following:
1. Temporarily change the datatype of your field to TEXT
2. Run the following update statement (changing the table name and field
UPDATE HyperLinks SET HyperLinks.EmailAddress = "#Mailto:" &
3. Change the datatype of y our field back to Hyperlink.
I did it and worked
Thank you for taking the time to report an issue.
What's wrong... Please write below.
The address is not a hyperlink but I wish to make it so. Is there some way to do that without modifying each record?
This works fine for standard mail merge (letters, envelopes, labels) I have been asked by the charity I created it for to also use it for mailmerging into emails. The data in the temporary table contains an email address (as a hyperlink) and when that hyperlink is clicked it opens up the default client as expected.
In the mail merge process, at the end stage when the emails are sent to Outlook it fails because what is sent as the address is (for an actual address of [LINK]) [@email]#mailto:[@email]# which Outlook does not recognise. Iwould have expected the address sent only to be like mailto:[@email]#
Write("" & RecordSet.Fields("webadd") & "")
Nothing shows up from the database with this. The data in the database is text.
Second question can I take a query with a field which is text and a field which is hyperlink and have a calculated field which displays as the text but is the same hyperlink that the hyperlink field is.
Private Sub lblReference_Click()
Dim strLinkUrl As String
Dim strPath As String
Dim strName As String
strName = lblReference.Text
strPath = "http://helpdesk.travel.com/tickets/"
strLinkUrl = strPath & strName
Me.lblReference.Hyperlink.Address = strLinkUrl
the data lblReference text field is a 5 digit number e.g. 12345 so I want to be able to go to the following address when I click on the lblReference field: http://helpdesk.travel.com/tickets/12345
however when I try to I get the following error:
run time error: '7980' the HyperlinkAddress or HyperlinkSubAddress property is read-only for this hyperlink.
can anyone advise me in simple terms what I am doing wrong and what I am supposed to be doing please