group e-mail mailto:

  • Thread starter Thread starter mace
  • Start date Start date
M

mace

Hi,

I have a access database with contacts and their e-
mailaddresses. I want to create a page(html) or a form
with a clickable button/spot that actually only makes a
mailto:(retreives e-mailaddresses from the database) into
Outlook TO: . seems to me like simple thing to do however
I have not figured it out yet.

thanks in advance
newbie
 
I want it to be a clickable link. found below code but it
doesnt seem to work. any ideas ???




Private Sub Email_DblClick(Cancel As Integer)


Dim strEmail as String

strEmail = "mailto:" & Me.
Application.FollowHyperlink Address:=strEmail

End Sub


Substitute your actual field name for EMail in the above
code.
 
I want it to be a clickable link. found below code but it
doesnt seem to work. any ideas ??? ..
..
..
Private Sub Email_DblClick(Cancel As Integer)


Dim strEmail as String

strEmail = "mailto:" & Me.
Application.FollowHyperlink Address:=strEmail

End Sub[/QUOTE]

Spaces in the string ? (just a stupid idea popping up), so trim() ?
Click to expand...
 
Good call. There is a chance of a trailing space. Email can have no spaces
anywhere in the string.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

flupp said:
I want it to be a clickable link. found below code but it
doesnt seem to work. any ideas ??? .
.
.
Private Sub Email_DblClick(Cancel As Integer)


Dim strEmail as String

strEmail = "mailto:" & Me.
Application.FollowHyperlink Address:=strEmail

End Sub[/QUOTE]

Spaces in the string ? (just a stupid idea popping up), so trim() ?
[/QUOTE]
Click to expand...
Click to expand...
 
Back
Top