| | |
|
|
|
into a live mailto link? |
|---|
| message from joe thompson on 11 May 2004 |
What is the easiest way of turning an email field in an
access form into a live mailto link?
Thanks
Joe
|
| Jim/Chris replied to joe thompson on 11 May 2004 |
I got this from Fred and it works great
You do not need to use the hyperlink datatype to send an
email to the address. Use a regular Text DataType instead.
Code the Double-click event of the form control that shows
the field:
Application.FollowHyperlink "Mailto:" & [ControlName]
Making corrections to the text field is much easier than
editing a
hyperlink field.
Jim
|
| Kailash Kalyani replied to joe thompson on 11 May 2004 |
Set the onClick event on the form to run the shell command
mailto:user@domain.com
shell ("explorer mailto:user@domain.com")
The other option is to have a hyperlink on your form that does the job..
Access allows hyperlinks... labels have a property called hyperlink address
where you could fill in the mailto link at runtime.
hope that helps.
|
| joe Thompson replied to Kailash Kalyani on 11 May 2004 |
Thanks Kailash
The problem I have is that user@domain.com is not static
each form record has a different entery based on the
batabase. I need some way to say
On click > mailto: [email field value]
Regards
Joe
command
that does the job..
called hyperlink address
|
| Arvin Meyer replied to joe Thompson on 11 May 2004 |
Private Sub txtEmailAddress_DblClick(Cancel As Integer)
Dim strMail As String
strMail = "#MailTo:" & Me.txtEmailAddress & "#"
Application.FollowHyperlink HyperlinkPart(strMail, acAddress)
End Sub
Add some error handling and you're done.
|
|
Archived message: into a live mailto link? (MS Access)
