Email hyperkobling

Dit Hyperlink skal indtastes således:

mailto:mugs@mail.dk

I tabellen

Evt. kan du lade være at indtaste i tabellen, men lav en formular, sæt markøren i det tomme Hyperlink-felt > Indsæt Hyperlink. Her starter en lille guide, som giver dig et par funktionaliteter at vælge imellem.

mailto:adresse@domain.tld

Íf you only want to see the eamail address and not mailto: then use this format

tbs@io.dk#mailto:tbs@io.dk#

but I prefer to use a text feild and then us ecode to open email. For example in the fields on double click event you could use.


application.FollowHyperlink "mailto:" & me.FieldContainingEmail,,True

ok, jeg er mest med på Terry sitt forslag, men har er alltid så avansert i sine løsninger (: Det jeg tenkte mest på var et Egendefinert format i definisjonen av feltet, altså i utformingsvisning av tabellen.Access sier at man legge inn et egendefinert format, og jeg regner da med at formatet kan fikses som et Mail felt. Om ikke det er mulig, takker jeg for mange gode svar.

/ Bratlie

I must admit, I'm not too hot on using custom formatting. And I have a feelin that in thsi case it isnt possible. This is because you have to get the email into two parts of the hyperlink.

There is actually a bit of help in hyperlink fields. Maybe it would be an idea to look at these.

Hyperlink Property
See Also Applies To Example Specifics
You can use the Hyperlink property to return a reference to a Hyperlink object. You can use the Hyperlink property to access the properties and methods of a Hyperlink object associated with a command button, image, or label control. Read-only.

expression.Hyperlink

expression  Required. An expression that returns one of the objects in the Applies To list.

Remarks
The Hyperlink property is available only by using Visual Basic.

Example
The CreateHyperlink procedure in the following example sets the hyperlink properties for a command button, label, or image control to the address and subaddress values passed to the procedure. The address setting is an optional argument, because a hyperlink to an object in the current database uses only the subaddress setting, To try this example, create a form with two text box controls (txtAddress and txtSubAddress) and a command button (cmdFollowLink) and paste the following into the Declarations section of the form's module:

Private Sub cmdFollowLink_Click()
    CreateHyperlink Me!cmdFollowLink, Me!txtSubAddress, _
        Me!txtAddress
End Sub

Sub CreateHyperlink(ctlSelected As Control, _
    strSubAddress As String, Optional strAddress As String)
    Dim hlk As Hyperlink
    Select Case ctlSelected.ControlType
        Case acLabel, acImage, acCommandButton
            Set hlk = ctlSelected.Hyperlink
            With hlk
                If Not IsMissing(strAddress) Then
                    .Address = strAddress
                Else
                    .Address = ""
                End If
                .SubAddress = strSubAddress
                .Follow
                .Address = ""
                .SubAddress = ""
            End With
        Case Else
            MsgBox "The control '" & ctlSelected.Name _
                & "' does not support hyperlinks."
    End Select
End Sub



Enter Hyperlink in Help
thenalos look underthe "See Also" link for further info.

tak, hope you found an acceptable solution!